# npoi-examples

**Repository Path**: SmallUniv/npoi-examples

## Basic Information

- **Project Name**: npoi-examples
- **Description**: No description available
- **Primary Language**: C#
- **License**: GPL-3.0
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-06-24
- **Last Updated**: 2024-06-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# NPOI Examples

This repository is splitted from [NPOI master repository](https://github.com/nissl-lab/npoi) in order to manage the examples easily.

# About Donation 关于捐款
If you profits/benefits from NPOI and you believe it's useful, please [sponsor me via Github Sponsor](https://github.com/sponsors/tonyqus) or [donate this project](https://github.com/nissl-lab/npoi/discussions/923). Thank you!

如果您从NPOI受益或实现盈利，请通过[Github Sponsor赞助我](https://github.com/sponsors/tonyqus)或[给该项目捐款](https://github.com/nissl-lab/npoi/discussions/923)，谢谢！

# Telegram User Group
Join us on telegram: https://t.me/npoidevs

# To Get Started with NPOI (on Windows 10)
1. Open PowerShell and run the following command:
```
git clone https://github.com/nissl-lab/npoi-examples
```
2. Open npoi-examples/ss/CalendarDemo/CalendarDemo.csproj with Visual Studio 2019 community version and click 'Run program' button
3. You will see a new generated file called Calendar.xls under npoi-examples/ss/CalendarDemo/bin/Debug folder
4. Open the Calendar.xls with Microsoft Excel or Kingsoft WPS 
5. Go back to Powershell window and run the following command
```
cd npoi-examples/ss/CalendarDemo/bin/Debug
./CalendarDemo -xlsx 
```
6. You will see a new generated file called Calendar.xlsx under npoi-examples/ss/CalendarDemo/bin/Debug folder
7. 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|