EPPlus 4.5.2.1
New features in version 4.5:
* .NET Core support
* Sparklines
* Sort method added to ExcelRange
* Bug fixes and minor changes, see below and visit https://github.com/JanKallman/EPPlus for tutorials, samples and the latest information
Important Notes:
Breaking change in .NET Core: The Worksheets collection will be zero based as default.
This can be altered by setting the ExcelPackage.Compatibility.IsWorksheets1Based to true.
.NET Core will have this property set to false, and .Net 3.5 and .Net 4 version will have this property set to true for backward compatibility reasons.
This property can also be set via the appsettings.json file in .Net Core or the app.config file. See sample project for examples!
.NET Core uses a preview of System.Drawing.Common, so be aware of that. We will update it as Microsoft releases newer versions.
System.Drawing.Common requires libgdiplus to be installed on non-Windows operating systems.
Use your favorite package manager to install it.
For example:
Homebrew on MacOS:
brew install mono-libgdiplus
apt-get:
apt-get install libgdiplus
EPPlus-A .NET Spreadsheet API
Changes
4.5.2.1
* Upgraded System.Drawing.Common for .NET Core to 4.5.0
* Fixed problem with Apostrophe in worksheet name
4.5.2
* Upgraded System.Drawing.Common to 4.5.0-rc1
* Optimized image handling
* External Streams are not closed when disposing the package
* Fixed issue with Floor and Celing functions
* And more bugfixes, see https://github.com/JanKallman/EPPlus/commits/master
4.5.1
* Added web sample for .NET Core from Vahid Nasiri
* Added sparkline sample to sample project
* Fixed a few problems related to .NET Core on Mac
4.5.0.3
* Fix for compound documents (VBA and Encryption).
* Fix for Excel 2010 sha1 hashed agile encryption.
* Upgraded System.Drawing.Common to 4.5.0-preview1-26216-02
* Also see https://github.com/JanKallman/EPPlus/commits/master
4.5.0.2 rc
* Merge in e few pull requests and fixed a few issues. See https://github.com/JanKallman/EPPlus/commits/master
4.5.0.1 Beta 2
* Added sparkline support.
* Switched targetframework from netcoreapp2.0 to netstandardapp2.0
* Replaced CoreCompat.System.Drawing.v2 with System.Drawing.Common
* Fixed a few issues. See https://github.com/JanKallman/EPPlus/commits/master
4.5.0.0 Beta 1
* .Net Core support.
* Added ExcelPackage.Compatibility.IsWorksheets1Based to remove inconsistent 1 base collection on the worksheets collection.
Note: .Net Core will have this property set to false, and .Net 3.5 and .Net 4 version will have this property set to true for backward compatibility reasons.
This property can be set via the appsettings.json file in .Net Core or the app.config file. See sample project for examples.
* RoundedCorners property Add to ExcelChart
* DataTable propery Added to ExcelPlotArea for charts
* Sort method added on ExcelRange
* Added functions NETWORKDAYS.INTL and NETWORKDAYS.
* And a lot of bug fixes. See https://github.com/JanKallman/EPPlus/commits/master
4.1.1
* Fix VBA bug in Excel 2016 - 1708 and later
4.1
* Added functions Rank, Rank.eq, Rank.avg and Search
* Applied a whole bunch of pull requests...
* Performance and memory usage tweaks
* Ability to set and retrieve 'custom' extended application properties.
* Added style QuotePrefix
* Added support for MajorTimeUnit and MinorTimeUnit to chart axes
* Added GapWidth Property to BarChart and Gapwidth.
* Added Fill and Border properties to ChartSerie.
* Added support for MajorTimeUnit and MinorTimeUnit to chart axes
* Insert/delete row/column now shifts named ranges, comments, tables and pivottables.
* And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details
4.0.5 Fixes
* Switched to Visual Studio 2015 for code and sample projects.
* Added LineColor, MarkerSize, LineWidth and MarkerLineColor properties to line charts
* Added LineEnd properties to shapes
* Added functions Value, DateValue, TimeValue
* Removed WPF depedency.
* And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details
4.0.4 Fixes
* Added functions Daverage, Dvar Dvarp, DMax, DMin DSum, DGet, DCount and DCountA
* Exposed the formula parser logging functionality via FormulaParserManager.
* And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details
4.0.3 Fixes
* Added compilation directive for MONO (Thanks Danny)
* Added functions IfError, Char, Error.Type, Degrees, Fixed, IsNonText, IfNa and SumIfs
* And fixed a lot of issues. See http://epplus.codeplex.com/SourceControl/list/changesets for more details
4.0.2 Fixes
* Fixes a whole bunch of bugs related to the cell store (Worksheet.InsertColumn, Worksheet.InsertRow, Worksheet.DeleteColumn, Worksheet.DeleteRow, Range.Copy, Range.Clear)
* Added functions Acos, Acosh, Asinh, Atanh, Atan, CountBlank, CountIfs, Mina, Offset, Median, Hyperlink, Rept
* Fix for reading Excel comment content from the t-element.
* Fix to make Range.LoadFromCollection work better with inheritance
* And alot of other small fixes
4.0.1 Fixes
* VBA unreadable content
* Fixed a few issues with InsertRow and DeleteRow
* Fixed bug in Average and AverageA
* Handling of Div/0 in functions
* Fixed VBA CodeModule error when copying a worksheet.
* Value decoding when reading str element for cell value.
* Better exception when accessing a worksheet out of range in the Excelworksheets indexer.
* Added Small and Large function to formula parser. Performance fix when encountering an unknown function.
* Fixed handling strings in formulas
* Calculate hangs if formula start with a parenthesis.
* Worksheet.Dimension returned an invalid range in some cases.
* Rowheight was wrong in some cases.
* ExcelSeries.Header had an incorrect validation check.
New features 4.0
Replaced Packaging API with DotNetZip
* This will remove any problems with Isolated Storage and enable multithreading
New Cell store
* Less memory consumption
* Insert columns (not on the range level)
* Faster row inserts,
Formula Parser
* Calculates all formulas in a workbook, a worksheet or in a specified range
* 100+ functions implemented
* Access via Calculate methods on Workbook, Worksheet and Range objects.
* Add custom/missing Excel functions via Workbook. FormulaParserManager.
* Samples added to the EPPlusSamples project.
The formula parser does not support Array Formulas
* Intersect operator (Space)
* References to external workbooks
* And probably a whole lot of other stuff as well :)
Performance
*Of course the performance of the formula parser is nowhere near Excels. Our focus has been functionality.
Agile Encryption (Office 2012-)
* Support for newer type of encryption.
Minor new features
* Chart worksheets
* New Chart Types Bubblecharts
* Radar Charts
* Area Charts
* And lots of bug fixes...
Beta 2 Changes
* Fixed bug when using RepeatColumns & RepeatRows at the same time.
* VBA project will be left untouched if it�s not accessed.
* Fixed problem with strings on save.
* Added locks to the cell store for access by multiple threads.
* Implemented Indirect function
* Used DisplayNameAttribute to generate column headers from LoadFromCollection
* Rewrote ExcelRangeBase.Copy function.
* Added caching to Save ZipStream for Cells and shared strings to speed up the Save method.
* Added Missing InsertColumn and DeleteColumn
* Added pull request to support Date1904
* Added pull request ExcelWorksheet. LoadFromDataReader
Release Candidate changes
* Fixed some problems with Range.Copy Function
* InsertColumn and Delete column didn't work in some cases
* Chart.DisplayBlankAs had the wrong default type in Excel 2010+
* Datavalidation list overflow caused corruption of the package
* Fixed a few Calculation when referring ranges (for exa
没有合适的资源?快使用搜索试试~ 我知道了~
NPOI和EPPlus实现.NET的Excel导入导出操作(类库+操作类+实例)
共60个文件
cs:14个
dll:10个
cache:6个
4星 · 超过85%的资源 需积分: 44 110 下载量 119 浏览量
2018-09-30
17:21:50
上传
评论 1
收藏 6.05MB ZIP 举报
温馨提示
NPOI和EPPlus实现.NET的Excel导入导出操作(类库+操作类+实例) NPOI实现.NET的Excel导入导出功能,EPPlus实现Excel的导出单个和多个Worksheet操作;可兼容各种版本的 Office 和 WPF 文件的打开,简单实用,里面有NPOI类库+Excel的操作帮助类+实例调用代码; 一看便知怎么使用了,简洁明了。
资源推荐
资源详情
资源评论
收起资源包目录
Fun.ExcelReport.zip (60个子文件)
Fun.ExcelReport
ReportHelper
RandomHelper.cs 3KB
bin
Debug
ReportHelper.dll 17KB
NPOI.dll 1.22MB
ReportHelper.pdb 32KB
Release
obj
Debug
ReportHelper.dll 17KB
TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs 0B
ReportHelper.csprojResolveAssemblyReference.cache 10KB
ReportHelper.pdb 32KB
ReportHelper.csproj.CoreCompileInputs.cache 42B
DesignTimeResolveAssemblyReferencesInput.cache 7KB
TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs 0B
ReportHelper.csproj.FileListAbsolute.txt 612B
ReportHelper.csproj.CopyComplete 0B
TempPE
TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs 0B
Properties
AssemblyInfo.cs 1KB
ReportHelper.csproj 2KB
UsersNP.cs 1KB
NPOIHelper.cs 18KB
ReportTest
bin
Debug
ReportTest.exe.config 189B
ReportHelper.dll 17KB
EPPlus.dll 1.24MB
NPOI.dll 1.22MB
ReportHelper.pdb 32KB
ReportTest.pdb 18KB
ReportTest.exe 8KB
EPPlus.xml 1.53MB
ExcelTemplate
UsersAddress.xlsx 10KB
Users.xlsx 9KB
obj
Debug
ReportTest.csproj.CopyComplete 0B
TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs 0B
ReportTest.csprojResolveAssemblyReference.cache 58KB
DesignTimeResolveAssemblyReferencesInput.cache 7KB
ReportTest.pdb 18KB
ReportTest.exe 8KB
TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs 0B
TempPE
ReportTest.csproj.CoreCompileInputs.cache 42B
TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs 0B
ReportTest.csproj.FileListAbsolute.txt 1KB
Properties
AssemblyInfo.cs 1KB
Program.cs 474B
ReportTest.csproj 3KB
NpoiTest.cs 1KB
App.config 189B
ExcelWorkbookTest.cs 5KB
packages.config 136B
ExcelTemplate
UsersAddress.xlsx 10KB
Users.xlsx 9KB
.vs
Fun.ExcelReport
v15
.suo 43KB
Server
sqlite3
db.lock 0B
storage.ide 912KB
packages
EPPlus.4.5.2.1
EPPlus.4.5.2.1.nupkg 1.89MB
readme.txt 8KB
lib
netstandard2.0
EPPlus.dll 1.23MB
EPPlus.xml 1.53MB
net35
EPPlus.dll 1.23MB
EPPlus.xml 1.53MB
net40
EPPlus.dll 1.24MB
EPPlus.xml 1.53MB
Fun.ExcelReport.sln 2KB
lib
NPOI.dll 1.22MB
共 60 条
- 1
资源评论
- xj56ai2019-04-09只有导入。。。。
林海峰
- 粉丝: 27
- 资源: 40
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于python实现的三次样条插值和均值插值法实现
- Python语言教程2-python批量图片大小处理-多文件夹
- Python语言教程1-python批量图片重命名,将后缀某几个不想要的字去除
- Space Combat Kit 太空战斗套件Unity游戏开发插件资源unitypackage C#
- Universal Device Preview 通用设备预览Unity游戏开发插件资源unitypackage
- Paladin Anim Set 圣骑士动画集Unity游戏动作动画插件资源unitypackage
- 计算机财务管理期末考报表部分题目及答案.doc
- 计算机软件维护论文.doc
- 计算机软件著作权授权书.docx
- 计算机键盘教学案例.doc
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功