2.3.0 (Mar, 2017��
New Features
- implement XSSF Streaming
BUG Fixes
- Fix GZIPSheetDataWriter
- Hold file handler when OOXML zip package is closed
- Fix test cases
2.2.1 (May,2016)
Bug Fixes
- Fix a lot of serialization issue of ooxml issue
- Fix phonetic guides tag reading/writing issue
- Fix XWPFRun SetText exception issue
- Fix xml security issue
- Optimize memory for AutoResizeColumn
- Fix sqref property is missing on ProtectedRange
- Fix drawing ooxml issue and cell value bug
- Fix numFmtId property issue on NumFmt node
- Fix ooxml issues for RadarChart and CellStyle
- Fix xfrm namespace issue in ooxml
- Fix ScatterChart issue in ooxml
- Fix ooxml bugs in Vml entities
- fix bug when call ISheet.RemoveRow, it removes a wrong row
- Don't close zip stream when zipoutputstream finish writing
2.2.0 (Aug, 2015)
New Feature
1. Implement FIXED, PROPER, DMIN and DGET functions
2. XSSF support for evaluating formula references to other Workbooks
3. Read text from SDTs at the table cell level, including (sometimes) Cover Page, Table of Contents and Bibliography
4. Double Strikethrough support for XWPF runs
5. XSSFSheet support for getDrawingPatriarch(), alongside the existing createDrawingPatriarch() method
6. Start on common interfaces for Paragraphs and Character Runs for XWPF
7. Basic text extractor for older Excel 4,5 and 95 formats
8. Add NPOIFS in-place write support, including updating the contents of existing entries
9. Support loading .xlsx files with no Styles Table
POI Bug fixes
57880 - Handle >32,767 cell styles and formats in XSSF (file format limit is 64,000)
57826 - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted
56017 - Fix shifting comments with shifted rows
56295 - Fix cloning of styles across workbooks and handling of default value of attribute applyFill
56380 - Remove limitation of 1024 comments per Workbook
56467 - Fix cloning of sheets with pictures
57171 - Adjust the active sheet in setSheetOrder()
57163 - Adjust the active sheet in removeSheet()
57165 - Avoid PartAlreadyExistsException when removing/cloning sheets
57196 - Resolve RefEval to it's inner ValueEval in Hex2Dec
57482 - Handle XSLX files with no shared strings table in read-only mode
46898 - XSSF: Return #VALUE! for circular references.
46912 - Add methods to query outline level for HSSF and XSSF
49541 - Mapping of symbol characters to unicode equivalent
57007 - Add initial implementations of DMIN and DGET functions
57373 - Fix get/setFirstVisibleTab() for XSSFWorkbook
57231 - Add missing ArrayRecord.clone()
56511 - Fix NullPointerException for RichText strings with no formatting for some runs.
56888 - XSSFDataValidation ignores "allow blank" read from sheet, assumes true
57236 -
57254 - XWPF: Correctly build internal list of styles when styles are added
57312 - XWPF: Add check for null value of underline w:val
57355 -
57164 - XSSFDrawing.createCellComment() does not honor dx and dy values passed in
57003 - Add implementation of function FIXED
57185 - Correct naming from "Serie" to "Series"
57010 - Add implementation of function PROPER
55280 - XSSF: Greatly improve performance of shifting rows in sheets with many merged regions.
48195 - Formulas: Fix incorrect evaluation of IF() with ROW()/COLUMN() as else-result.
56914 - XSSFRowShifter.updateConditionalFormatting throws IOOBE when there are more than 1 CTConditionalFormatting
51222 - XSSFColor.getARGBHex() returns wrong color for Excel 2007 xlsx file
56864 - XWPFLatentStyles.isLatentStyle always returns true if there is at least 1 lsdException
57151 - And documentation and validation in CellRangeAddress to prevent invalid row/column combinations
2.1.3.1 (Feb., 2015)
Bug Fixes
a. fix word serialization issues
b. fix CloneStyleFrom issue
c. Fix vertical alignment default value for XSSFCell
d. fix setAutoFilter change range issue
e. fix EDate function
f. fix FormatException in FormulaParser
g. fix Comment random Shape issue (comment serialization issue)
h. fix not be able to unlock the cell issue
POI BUG FIXES
55729 - DataFormatter should format Error cells, returning the Excel error string
49237 - HSSF Row Style XfIndex is 12 not 16 bits of data
54607 - NullPointerException in XSSFSheet.getTopRow() when the top row is 1
55745 - fix handling of tables in XSSF if there are comments as well
54673 - Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
55047 - REPT formula support
55042 - COMPLEX formula support
55041 - CODE formula support
54508 - EDATE formula support
53966 - IfError support (from Analysis Toolpak)
54402 - IfError handling of indirect references
New feature
a. Add ReplaceText to XWPFParagraph and XWPFRun
b. adjust ExcelExtractor interface
c. Improving comment missing handling in HSSFSheet
d. copy hyperlink in CopySheet and fix some bugs
e. Implement ChartSheet in OpenXmlFormats
f. Implement shrinktofit for XSSF
2.1.3 (Dec., 2014)
Bug Fixes
a. fix 2 charts insert in the same sheet issue
b. fix a lot of Excel 2007 serialization issues
c. fix some Word 2007 serialiation issues
d. fix RemoteSheetAt bug
e. support changing background in XWPF
f. fix Uri-related issues on Mono
New examples
SetIsRightToLeftInXlsx - show how to use IsRightToLeft property
ExtractPicturesFromXlsx - show how to extract pictures from Excel 2007 file
SetRowStyle - show how to set whole row style with simple code
2.1.1 (Jun., 2014)
New Features
a. XSSFSheet.CopySheet
b. Excel2Html for XSSF and HSSF
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
New examples
a. XSSF.DownloadXlsx
b. XSSF.ConditionFormats
c. XSSF.LineChart
d. XWPF.InsertPicturesInWord
2.0 [v2.0.6] (Jan., 2014)
a. fix a lot of xml serialization issue for OOXML (2.0.5 will corrupt some xlsx and docx files)
b. implement XSSFCell.IsMergedCell
c. IWorkbook implements IList<ISheet>
2.0 Beta 2 [v2.0.5] (Dec, 2013)
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
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 nam
没有合适的资源?快使用搜索试试~ 我知道了~
C#导出Excel复杂表头解决方案
共344个文件
dll:109个
xml:55个
nupkg:29个
5星 · 超过95%的资源 需积分: 47 151 下载量 67 浏览量
2018-01-18
11:27:44
上传
评论 7
收藏 31.63MB RAR 举报
温馨提示
使用了一个高手的原有DEMO改造而成,优化了导出复杂表头增加样式过慢的问题。
资源推荐
资源详情
资源评论
收起资源包目录
C#导出Excel复杂表头解决方案 (344个子文件)
Global.asax 101B
ExcelTest.csprojResolveAssemblyReference.cache 142KB
DesignTimeResolveAssemblyReferencesInput.cache 12KB
ExcelTest.csproj.CoreCompileInputs.cache 42B
applicationhost.config 84KB
ApplicationInsights.config 6KB
ApplicationInsights.config 6KB
packages.config 3KB
Web.config 3KB
ExcelTest.dll.config 3KB
Web.config 2KB
VBCSCompiler.exe.config 2KB
vbc.exe.config 2KB
csc.exe.config 2KB
Web.Release.config 1KB
Web.Debug.config 1KB
ExcelTest.csproj.CopyComplete 0B
NPOIHelper.cs 35KB
HomeController.cs 3KB
AssemblyInfo.cs 1KB
BundleConfig.cs 1KB
RouteConfig.cs 602B
Global.asax.cs 591B
FilterConfig.cs 277B
TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs 0B
TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs 0B
TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs 0B
_Layout.cshtml 2KB
Index.cshtml 1KB
Contact.cshtml 457B
Error.cshtml 333B
About.cshtml 152B
_ViewStart.cshtml 57B
ExcelTest.csproj 14KB
bootstrap.css 118KB
bootstrap.css 118KB
bootstrap.min.css 96KB
bootstrap.min.css 96KB
Site.css 537B
Microsoft.CodeAnalysis.VisualBasic.dll 4.83MB
Microsoft.CodeAnalysis.CSharp.dll 4.02MB
NPOI.OpenXmlFormats.dll 2.02MB
NPOI.OpenXmlFormats.dll 2.02MB
NPOI.OpenXmlFormats.dll 2.02MB
Microsoft.CodeAnalysis.dll 1.95MB
Microsoft.AI.Agent.Intercept.dll 1.89MB
Microsoft.AI.Agent.Intercept.dll 1.89MB
Microsoft.AI.Agent.Intercept.dll 1.89MB
NPOI.dll 1.6MB
NPOI.dll 1.6MB
NPOI.dll 1.6MB
WebGrease.dll 1.22MB
WebGrease.dll 1.22MB
Microsoft.DiaSymReader.Native.amd64.dll 1.21MB
Microsoft.DiaSymReader.Native.x86.dll 945KB
System.Web.Mvc.dll 553KB
System.Web.Mvc.dll 553KB
NPOI.OOXML.dll 524KB
NPOI.OOXML.dll 524KB
Newtonsoft.Json.dll 491KB
Newtonsoft.Json.dll 491KB
NPOI.OOXML.dll 483KB
Newtonsoft.Json.dll 482KB
Newtonsoft.Json.dll 482KB
Newtonsoft.Json.dll 437KB
Newtonsoft.Json.dll 435KB
Newtonsoft.Json.dll 420KB
System.Reflection.Metadata.dll 416KB
Newtonsoft.Json.dll 378KB
System.Web.Razor.dll 266KB
System.Web.Razor.dll 266KB
SharpZipLib.Silverlight3.dll 208KB
SharpZipLib.Silverlight4.dll 207KB
System.Web.WebPages.dll 207KB
System.Web.WebPages.dll 207KB
ICSharpCode.SharpZipLib.dll 204KB
ICSharpCode.SharpZipLib.dll 196KB
ICSharpCode.SharpZipLib.dll 196KB
System.Collections.Immutable.dll 196KB
Microsoft.ApplicationInsights.dll 184KB
Microsoft.ApplicationInsights.dll 184KB
Microsoft.ApplicationInsights.dll 153KB
Microsoft.ApplicationInsights.dll 151KB
Microsoft.ApplicationInsights.dll 145KB
Microsoft.ApplicationInsights.dll 142KB
Microsoft.ApplicationInsights.dll 142KB
Microsoft.ApplicationInsights.dll 141KB
System.Web.Helpers.dll 137KB
System.Web.Helpers.dll 137KB
Microsoft.AI.PerfCounterCollector.dll 129KB
Microsoft.AI.PerfCounterCollector.dll 127KB
Microsoft.AI.PerfCounterCollector.dll 127KB
Microsoft.CodeAnalysis.Scripting.dll 125KB
Microsoft.AI.ServerTelemetryChannel.dll 104KB
Microsoft.Build.Tasks.CodeAnalysis.dll 103KB
Microsoft.AI.ServerTelemetryChannel.dll 101KB
Microsoft.AI.ServerTelemetryChannel.dll 101KB
Antlr3.Runtime.dll 101KB
Antlr3.Runtime.dll 101KB
NPOI.OpenXml4Net.dll 89KB
共 344 条
- 1
- 2
- 3
- 4
资源评论
- weixin_388042612020-04-27我导出来提示:Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃。 已删除的记录: /xl/worksheets/sheet1.xml 部分的 合并单元格 这是什么情况
- itcoco2019-01-09谢谢分享,学习一下
- eacol2019-07-12测试过代码,可用!感谢
- baiq2018-10-25刚好能用上。
feiyit
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功