NPOI Examples
This repository is splitted from NPOI master repository in order to manage the examples easily.
About Donation
Since Github sponsorship is not supported in China so far, it's hard to get donation from Github channel. I'm strictly limiting my contribution time on NPOI these 2 years although it looks to be still maintained well. If you profits/benefits from NPOI and you believe it's useful, please donate this project. Thank you!
Telegram User Group
Join us on telegram: https://t.me/npoidevs
To Get Started with NPOI (on Windows 10)
- Open PowerShell and run the following command:
git clone https://github.com/nissl-lab/npoi-examples
- Open npoi-examples/ss/CalendarDemo/CalendarDemo.csproj with Visual Studio 2019 community version and click 'Run program' button
- You will see a new generated file called Calendar.xls under npoi-examples/ss/CalendarDemo/bin/Debug folder
- Open the Calendar.xls with Microsoft Excel or Kingsoft WPS
- Go back to Powershell window and run the following command
cd npoi-examples/ss/CalendarDemo/bin/Debug
./CalendarDemo -xlsx
- You will see a new generated file called Calendar.xlsx under npoi-examples/ss/CalendarDemo/bin/Debug folder
- Open the Calendar.xlsx with Microsoft Excel or Kingsoft WPS
Conclusion: The result of Calendar.xls and Calendar.xlsx looks same in Microsoft Excel or Kingsoft WPS but they are totally different file formats generated by NPOI.
Folders Explained
| Folder Name | Description |
|---|---|
| POIFS | OLE2/ActiveX document examples |
| HSSF | examples for Microsoft Excel BIFF(Excel 97-2003, xls) |
| SS | Excel Common examples for both Excel 2003(xls) and Excel 2007+(xlsx) |
| XSSF | Excel 2007(xlsx) examples |
| XWPF | Word 2007(docx) examples |
| OOXML | OpenXml format low-level examples |
| ScratchPad/HWPF | Word 2003(doc) examples |