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 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
没有合适的资源?快使用搜索试试~ 我知道了~
.net 帮助类最全汇总,使用C#语法,集成了nuget,涉及到的文件操作,微信,Redis,Mongo,FTP等技术的帮助类
共1188个文件
dll:404个
xml:195个
cs:189个
需积分: 9 1 下载量 91 浏览量
2022-07-03
15:06:17
上传
评论
收藏 115.81MB RAR 举报
温馨提示
今天整理电脑资料的之后,发现了平时开发写的小例子,现在整理出来大家分享给大家,大致包含如下资源压缩解压缩、正则表达式、序列化、文件操作类、条形码帮助类、视频转换帮助类、二维码操作类、RDLC打印帮助类、AD域帮助类、文件操作类,Reids帮助类等 还有主流的微信开发帮助类、FTP操作类,Excel操作类,CSV和XML的操作类,整个项目非常大,下载完成之后,可以根据需要进行查找,防止编译不通过,packages文件夹也压缩在包中,方便大家使用。
资源详情
资源评论
资源推荐
收起资源包目录
.net 帮助类最全汇总,使用C#语法,集成了nuget,涉及到的文件操作,微信,Redis,Mongo,FTP等技术的帮助类 (1188个子文件)
_._ 3B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
System.Data.SQLite.dll.altconfig 739B
System.Data.SQLite.dll.altconfig 739B
System.Data.SQLite.dll.altconfig 739B
System.Data.SQLite.dll.altconfig 739B
System.Data.SQLite.dll.altconfig 739B
CHANGES 10KB
Common.Utility帮助文档.chm 2.05MB
Helper帮助文档.chm 1.19MB
log4net.config 3KB
Web.config 3KB
app.config 3KB
packages.config 2KB
Redirect.VS11.config 735B
Redirect.config 487B
repositories.config 177B
CNDate.cs 62KB
ADHelp.cs 46KB
DbHelperSQL.cs 39KB
DbHelperSQLP.cs 39KB
DbHelperMySQL.cs 33KB
SegList.cs 32KB
Utility.cs 32KB
SmtpServerHelper.cs 30KB
PicDeal.cs 29KB
DirFile.cs 28KB
HttpHelper.cs 26KB
FTPClient.cs 26KB
OracleHelper.cs 25KB
Assistant.cs 23KB
MongoDBHelper.cs 23KB
BarCodeToHTML.cs 23KB
FileOperate.cs 22KB
ImageClass.cs 22KB
RedisSomeHelper.cs 22KB
XMLProcess.cs 22KB
HtmlHelper.cs 21KB
PinYin.cs 20KB
ExcelHelper.cs 20KB
SqlHelper.cs 20KB
Tools.cs 20KB
TimeHelper.cs 20KB
WebClientHelper.cs 19KB
HttpProc.cs 18KB
StringHelper.cs 18KB
ImageUpload.cs 18KB
Pop3Client.cs 18KB
NetHelper.cs 17KB
NetHelper.cs 17KB
HTMLHelper.cs 17KB
DbHelperOra.cs 16KB
MySecurity.cs 16KB
DbHelperOleDb.cs 16KB
DbHelperSQLite.cs 16KB
DataToExcel.cs 16KB
ValidatorHelper.cs 15KB
PageHelper.cs 14KB
ConvertJson.cs 14KB
MimeReader.cs 14KB
BarCodeHelper.cs 13KB
SharpZip.cs 13KB
JavaScriptHelper.cs 13KB
AppMessage.cs 13KB
MimeEntity.cs 12KB
FTPHelper.cs 12KB
ManagedThreadPool.cs 12KB
EncryptionMD5.cs 12KB
VideoHelper.cs 12KB
SQLHelper.cs 11KB
OWCChart11.cs 11KB
ConvertJson.cs 11KB
RSACryption.cs 11KB
CAPTCHA.cs 11KB
Pop3Command.cs 11KB
VideoConvert.cs 10KB
NPOIHelper.cs 10KB
FTPOperater.cs 10KB
EcanConvertToCh.cs 10KB
ObjectConversion.cs 9KB
PageHelper.cs 9KB
GridViewHelper.cs 9KB
FormulaExpress.cs 9KB
XmlHelper.cs 9KB
共 1188 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
笨笨2020
- 粉丝: 3
- 资源: 23
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0