This repository is splitted from NPOI master repository in order to manage the examples easily.
If you profits/benefits from NPOI and you believe it's useful, please sponsor me via Github Sponsor or donate this project. Thank you!
如果您从NPOI受益或实现盈利，请通过Github Sponsor赞助我或给该项目捐款，谢谢！
Join us on telegram: https://t.me/npoidevs
- 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.
| 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 |