# npoi-examples

**Repository Path**: lb6181/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**: 2021-07-02
- **Last Updated**: 2021-07-02

## 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.

# 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|

[![Analytics](https://ga-beacon.appspot.com/UA-39118634-1/npoi-examples)](https://github.com/nissl-lab/npoi-examples)