NPOI.Excel 2.1.1

This project is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. It has a wide application.
For example, you can use it to
a. generate a Excel report without Microsoft Office suite installed on your server and more efficient than call Microsoft Excel ActiveX at background;
b. extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines).
c. extract images from Office documents
d. generate Excel sheets that contains formulas

Install-Package NPOI.Excel -Version 2.1.1

dotnet add package NPOI.Excel --version 2.1.1

<PackageReference Include="NPOI.Excel" Version="2.1.1" />

paket add NPOI.Excel --version 2.1.1

#r "nuget: NPOI.Excel, 2.1.1"

// Install NPOI.Excel as a Cake Addin
#addin nuget:?package=NPOI.Excel&version=2.1.1

// Install NPOI.Excel as a Cake Tool
#tool nuget:?package=NPOI.Excel&version=2.1.1

Release Notes

New Features
a. XSSFSheet.CopySheet
b. Excel2Html for XSSF
c. insert picture in word 2007
d. Implement IfError function in formula engine

Bug Fixes
a. fix conditional formatting issue
b. fix ctFont order issue
c. fix vertical alignment issue in XSSF
d. add IndexedColors to NPOI.SS.UserModel
e. fix decimal point issue in non-English culture
f. fix SetMargin issue in XSSF
g.fix multiple images insert issue in XSSF
h.fix rich text style missing issue in XSSF
i. fix cell comment shape (big arrow) in XSSF
j. WorkbookFactory for Excel 2007 doesn't occupy file.
k. fix XSSFCell.IsMergedCell
l. fix incorrect page margin value due to different culture
m. fix HSSFSheet.CopyTo doesn't copy rich text in cells
n. fix scroll bar and tabs missing in previous 2.1 release

Dependencies

This package has no dependencies.

Used By

Version History