NPOI.Excel
2.1.1
dotnet add package NPOI.Excel --version 2.1.1
NuGet\Install-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
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
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net is compatible. |
This package has no dependencies.
NuGet packages (3)
Showing the top 3 NuGet packages that depend on NPOI.Excel:
Package | Downloads |
---|---|
ScadaTools
Scada工具包 |
|
Lau.nuget.demo3
this nuget description |
|
Scaler.Excel
Scaler Excel库 |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
2.1.1 | 403,703 | 10/10/2014 |
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