• Stars
    star
    220
  • Rank 180,422 (Top 4 %)
  • Language
    C#
  • License
    GNU General Publi...
  • Created about 4 years ago
  • Updated 7 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

To get started with NPOI, here is all the official examples.

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)

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