Getting Started with NPOI - nissl-lab/npoi GitHub Wiki
Examples
We have huge examples for you to learn how to use NPOI.
Please click here for NPOI tutorials
General Comparison
| HSSFWorkbook | XSSFWorkbook | SXSSFWorkbook | |
|---|---|---|---|
| File Format | .xls (Excel 97-2003) | .xlsx (Excel 2007+) | .xlsx (Excel 2007+) |
| Format Type | BIFF8 binary | OpenXML | OpenXML |
| Max Rows per Sheet | 65,536 | 1,048,576 | 1,048,576 |
| Max Columns per Sheet | 256 | 16,384 | 16,384 |
| Streaming Workbook | No | No | Yes |
| Memory Usage | High | High | Low |
Linux Setup
https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux
3rd-party Tutorials/Blogs
Generate Excel With (NPOI) in C#
Read and Write Excel file in .NET Core using NPOI
Different Ways to Access Excel 2003 Workbooks using C#
Export to Excel using NPOI - C# and WEB API
How to read Excel 2007 documents using NPOI
How To Create Excel Spreadsheets Using NPOI
NPOI 2.0 - Converting Excel XLS documents to HTML format
How to Add Image to Excel Files using NPOI
NPOI with Excel Table and dynamic Chart
.NET Core使用NPOI将Excel中的数据批量导入到MySQL