NPOI 2.0.6
Prefix ReservedSee the version list below for details.
dotnet add package NPOI --version 2.0.6
NuGet\Install-Package NPOI -Version 2.0.6
<PackageReference Include="NPOI" Version="2.0.6" />
paket add NPOI --version 2.0.6
#r "nuget: NPOI, 2.0.6"
// Install NPOI as a Cake Addin #addin nuget:?package=NPOI&version=2.0.6 // Install NPOI as a Cake Tool #tool nuget:?package=NPOI&version=2.0.6
This project is the .NET version of POI from Apache Foundation. NPOI can read and write xls (Excel 97-2003), xlsx(Excel 2007+) and docx(Word 2007+)
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net20 is compatible. net35 was computed. net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- SharpZipLib (>= 0.86.0)
NuGet packages (947)
Showing the top 5 NuGet packages that depend on NPOI:
Package | Downloads |
---|---|
Npoi.Mapper
Convention-based mapper between strong typed object and Excel data via NPOI. |
|
ExcelMapper
An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods. |
|
HIC.RDMP.Plugin
Core package for plugin development |
|
BaseLibrary.ClassLibraryStand
Package Description |
|
Mooho.Base
摩赫基础框架 |
GitHub repositories (58)
Showing the top 5 popular GitHub repositories that depend on NPOI:
Repository | Stars |
---|---|
Uahh/ToastFish
一个利用摸鱼时间背单词的软件。
|
|
laochiangx/Common.Utility
Various helper class
|
|
Planshit/Tai
👻 在Windows上统计软件使用时长和网站浏览时长
|
|
ferventdesert/Hawk
visualized crawler & ETL IDE written with C#/WPF
|
|
mini-software/MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
|
Version | Downloads | Last updated | |
---|---|---|---|
2.7.1 | 1,082,451 | 7/3/2024 | |
2.7.0 | 1,737,596 | 3/25/2024 | |
2.6.2 | 3,344,114 | 9/11/2023 | |
2.6.1 | 1,030,732 | 7/11/2023 | |
2.6.0 | 4,880,328 | 11/17/2022 | |
2.5.6 | 9,370,854 | 4/26/2022 | |
2.5.5 | 5,191,543 | 10/25/2021 | |
2.5.4 | 1,977,898 | 7/29/2021 | |
2.5.3 | 2,234,104 | 4/18/2021 | |
2.5.2 | 2,640,674 | 12/5/2020 | |
2.5.1 | 5,788,561 | 4/4/2020 | |
2.4.1 | 8,790,046 | 12/18/2018 | |
2.3.0 | 3,719,101 | 3/20/2017 | |
2.2.1 | 1,948,145 | 5/31/2016 | |
2.1.3.1 | 1,379,188 | 2/22/2015 | |
2.1.3 | 135,032 | 12/31/2014 | |
2.0.6 | 431,510 | 4/12/2014 | |
1.2.5 | 392,216 | 7/29/2012 | |
1.2.4 | 78,881 | 11/15/2011 | |
1.2.3 | 67,318 | 1/12/2011 |
New features
a. Support Scatter chart in XSSF (xlsx) (other chart types are not supported yet)
b. Extract pictures from Excel (xlsx)
c. XWPF becomes stabler than before
d. Able to support xml:space="preserve" attribute
e. Add mono assembly in the release package
f. file generated by NPOI will contain NPOI tags in custom properties to identify the generator
g. Adjust some XWPF interfaces
h. implement XSSFCell.IsMergedCell
i. IWorkbook implements IList<ISheet>
Sample changes
a. add new samples like BigGridTest, WritePerformanceTest to test performance
b. add ScatterChart to show how to create Scatter chart
c. add LinkedDropDownList for both XSSF and HSSF
d. add MonthlySalaryReport to show how to use formula in XSSF
e. add CreateCustomProperties to show how to use custom props in XSSF and XWPF
Bug fixes
a. fix shift row issue in XSSFSheet
b. fix performance issue due to XmlSerializer. NPOI is getting rid of XmlSerializer.
c. reading/writing CT_Drawing
d. fix ddd pattern issue in CellDateFormatter
e. Change some common interfaces in NPOI.SS
f. fix OutOfMemory issue in MemoryPackagePart
g. Able to read AbsoluteAnchor, OneCellAnchor, TwoCellAnchor in drawing.xml
h. Formula will be calculated automatically after generation
i. improve performance for XSSF while creating new rows
For detail, please read https://npoi.codeplex.com/discussions/443655
j. fix name encoding issue of custom properties in HSSF
For detail, please read https://npoi.codeplex.com/workitem/12296
k. fix exception in HSSFRows.RemoveAllCells
l. fix CellStyle Hashtable comparison issue in class HSSFCellUtil. This can help prevent over 4000 styles issue from code.
m. Fix globalization issue in ExpandedDouble
n. fix a lot of xml serialization issue for OOXML
o. implement XSSFCell.IsMergedCell
p. IWorkbook implements IList<ISheet>