EPPlus 4.5.1
Create advanced Excel spreadsheets using .NET
Showing the top 20 packages that depend on EPPlus.
Packages | Downloads |
---|---|
BootstrapBlazor
Bootstrap UI components for Blazor and Razor Components
|
4 |
BootstrapBlazor.TableExport
Bootstrap UI components for Blazor and Razor Components
|
4 |
BootstrapBlazor.TableExport
Bootstrap UI components for Blazor and Razor Components
|
3 |
EPPlus.Core.Extensions
An extensions library for both EPPlus and EPPlus.Core packages to generate and manipulate Excel files easily.
|
3 |
BootstrapBlazor
Bootstrap UI components for Blazor and Razor Components
|
2 |
Magicodes.IE.Excel
导入导出通用库。
官方网址:http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
小店地址:https://shop113059108.taobao.com/
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.06.16**
- ** 【Nuget】版本更新到2.2.6**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
**2020.06.14**
- ** 【Nuget】版本更新到2.2.5**
- ** 【Excel导出】增加分栏、分sheet、追加rows导出 [#74](https://github.com/dotnetcore/Magicodes.IE/issues/74)**
- exporter.Append(list1).SeparateByColumn().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateBySheet().Append(list2).ExportAppendData(filePath);
- exporter.Append(list1).SeparateByRow().AppendHeaders().Append(list2).ExportAppendData(filePath);
- ** [Excel导出】修复‘IsAllowRepeat=true’ [#107](https://github.com/dotnetcore/Magicodes.IE/issues/107) **
- ** [Pdf导出】增加PDF扩展方法,支持通过以参数形式传递特性参数 [#104](https://github.com/dotnetcore/Magicodes.IE/issues/104) **
- `ExportListBytesByTemplate<T>(ICollection<T> data, PdfExporterAttribute pdfExporterAttribute,string temple);`
- `ExportBytesByTemplate<T>(T data, PdfExporterAttribute pdfExporterAttribute,string template);`
**2020.06.07**
- ** 【Nuget】版本更新到2.2.4**
- ** 【Excel导入】增加`导入失败`仅返回错误行功能**
- ** 【Excel导入】修复导入的空行标注位置偏移**
- ** 【Excel导出】增加`SeparateByColumn`进行分割追加列**
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.07.14**
- ** 【Nuget】版本更新到2.3.0-beta4**
**2020.07.13**
- ** 【Nuget】版本更新到2.3.0-beta3**
- 【PDF导出】修复Linux下导出PDf 出错问题 #125
**2020.07.06**
- ** 【Nuget】版本更新到2.3.0-beta2**
- 【Excel导出】导出业务错误数据支持直接返回错误数据的文件流字节
- 【Excel导出】对追加sheet实现同一个Model可自定义传入不同sheet名称
- exporter.Append(list1,"sheet1").SeparateBySheet().Append(list2).ExportAppendData(filePath);
- 【Nuget】针对于一些客户端不支持SemVer 2.0.0 进行采取兼容机制
**2020.06.22**
- ** 【Nuget】版本更新到2.3.0-beta1**
- ** 【Excel导出】添加对Excel模板导出函数的支持
- {{Formula::AVERAGE?params=G4:G6}}
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.04.16**
- **【Nuget】版本更新到2.2.0-beta9**
- **【Excel模板导出】修复只存在一列时的导出 [#73](https://github.com/dotnetcore/Magicodes.IE/issues/73)**
- **【Excel导入】支持返回表头和索引 [#76](https://github.com/dotnetcore/Magicodes.IE/issues/76)**
- **【Excel导入导入】[#63](https://github.com/dotnetcore/Magicodes.IE/issues/63)**
- 支持使用System.ComponentModel.DataAnnotations命名空间下的部分特性来控制导入导出,比如
- DisplayAttribute
- DisplayFormatAttribute
- DescriptionAttribute
- 封装简单的易于使用的单一特性,例如
- IEIgnoreAttribute(可作用于属性、枚举成员,可影响导入和导出)
**2020.04.02**
2.2.0-beta8
【Excel模板导出】支持图片 [#61](https://github.com/dotnetcore/Magicodes.IE/issues/61)
2.2.0-beta7
【Excel模板导出】修复渲染问题 [#51](https://github.com/dotnetcore/Magicodes.IE/issues/51)
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
2.2.0-beta8
【Excel模板导出】支持图片 [#61](https://github.com/dotnetcore/Magicodes.IE/issues/61)
2.2.0-beta7
【Excel模板导出】修复渲染问题 [#51](https://github.com/dotnetcore/Magicodes.IE/issues/51)
|
2 |
Magicodes.IE.Excel
导入导出通用库,通过导入导出DTO模型来控制导入和导出,支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址:http://www.cnblogs.com/codelove/
交流QQ群:85318032
**2020.07.06**
- ** 【Nuget】版本更新到2.3.0-beta2**
- 【Excel导出】导出业务错误数据支持直接返回错误数据的文件流字节
- 【Excel导出】对追加sheet实现同一个Model可自定义传入不同sheet名称
- exporter.Append(list1,"sheet1").SeparateBySheet().Append(list2).ExportAppendData(filePath);
- 【Nuget】针对于一些客户端不支持SemVer 2.0.0 进行采取兼容机制
**2020.06.22**
- ** 【Nuget】版本更新到2.3.0-beta1**
- ** 【Excel导出】添加对Excel模板导出函数的支持
- {{Formula::AVERAGE?params=G4:G6}}
**2020.06.17**
- ** 【Nuget】版本更新到2.2.7**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
**2020.06.16**
- ** 【Nuget】版本更新到2.2.6**
- ** 【HTML导出】添加对NETCore2.2模板引擎的支持
|
2 |
EPPlus 4.5.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.1
* Added web sample for .NET Core from Vahid Nasiri
* Added sample 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 example If function)
* Added ChartAxis.DisplayUnit
* Fixed a bug related to shared formulas
* Named styles failed in some cases.
* Style.Indent got an invalid value in some cases.
* Fixed a problem with AutofitColumns method.
* Performance fix.
* A whole lot of other small fixes.
.NET Framework 3.5
- No dependencies.
.NET Standard 2.0
- System.Xml.XmlDocument (>= 4.3.0)
- System.Xml.XPath.XmlDocument (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Security.Cryptography.X509Certificates (>= 4.3.0)
- System.Security.Claims (>= 4.3.0)
- System.Security.Cryptography.Pkcs (>= 4.4.0)
- System.Drawing.Common (>= 4.5.0-preview1-26216-02)
- System.Data.Common (>= 4.3.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- Microsoft.Extensions.Configuration.Json (>= 2.0.0)
- System.Reflection (>= 4.3.0)
.NET Framework 4.0
- No dependencies.
Version | Downloads | Last updated |
---|---|---|
8.0.5 | 5 | 2025/5/25 |
8.0.4 | 4 | 2025/5/24 |
8.0.3 | 5 | 2025/5/24 |
8.0.2 | 2 | 2025/5/26 |
8.0.1 | 1 | 2025/5/26 |
8.0.0-rc | 1 | 2025/5/26 |
8.0.0-beta | 1 | 2025/5/26 |
7.7.2 | 4 | 2025/5/24 |
7.7.1 | 1 | 2025/5/27 |
7.7.0 | 1 | 2025/5/26 |
7.6.1 | 1 | 2025/5/27 |
7.6.0 | 1 | 2025/5/26 |
7.5.3 | 1 | 2025/5/27 |
7.5.2 | 1 | 2025/5/26 |
7.5.1 | 1 | 2025/5/26 |
7.5.0 | 1 | 2025/5/26 |
7.4.2 | 1 | 2025/5/26 |
7.4.1 | 1 | 2025/5/26 |
7.4.0 | 1 | 2025/5/27 |
7.3.2 | 4 | 2025/5/24 |
7.3.1 | 1 | 2025/5/26 |
7.3.0 | 1 | 2025/5/26 |
7.2.2 | 1 | 2025/5/26 |
7.2.1 | 2 | 2025/5/26 |
7.2.0 | 2 | 2025/5/26 |
7.1.3 | 1 | 2025/5/26 |
7.1.2 | 1 | 2025/5/26 |
7.1.1 | 2 | 2025/5/26 |
7.1.0 | 2 | 2025/5/26 |
7.0.10 | 1 | 2025/5/28 |
7.0.9 | 4 | 2025/5/25 |
7.0.8 | 2 | 2025/5/26 |
7.0.7 | 3 | 2025/5/26 |
7.0.6 | 1 | 2025/5/26 |
7.0.5 | 1 | 2025/5/26 |
7.0.4 | 1 | 2025/5/26 |
7.0.3 | 1 | 2025/5/26 |
7.0.2 | 1 | 2025/5/26 |
7.0.1 | 1 | 2025/5/26 |
7.0.0 | 1 | 2025/5/26 |
6.2.19 | 1 | 2025/5/26 |
6.2.18 | 1 | 2025/5/26 |
6.2.17 | 2 | 2025/5/26 |
6.2.16 | 1 | 2025/5/30 |
6.2.15 | 1 | 2025/5/26 |
6.2.14 | 1 | 2025/5/26 |
6.2.13 | 3 | 2025/5/24 |
6.2.12 | 1 | 2025/5/27 |
6.2.11 | 1 | 2025/5/26 |
6.2.10 | 1 | 2025/5/26 |
6.2.9 | 3 | 2025/5/27 |
6.2.8 | 2 | 2025/5/26 |
6.2.7 | 1 | 2025/5/26 |
6.2.6 | 3 | 2025/5/24 |
6.2.5 | 1 | 2025/5/27 |
6.2.4 | 1 | 2025/5/26 |
6.2.3 | 1 | 2025/5/26 |
6.2.2 | 1 | 2025/5/26 |
6.2.1 | 2 | 2025/5/26 |
6.2.0 | 1 | 2025/5/26 |
6.1.3 | 1 | 2025/5/26 |
6.1.2 | 1 | 2025/5/26 |
6.1.1 | 4 | 2025/5/22 |
6.1.0 | 1 | 2025/5/26 |
6.0.8 | 1 | 2025/5/26 |
6.0.7 | 1 | 2025/5/26 |
6.0.6 | 1 | 2025/5/27 |
6.0.5 | 1 | 2025/5/26 |
6.0.4 | 1 | 2025/5/26 |
6.0.3 | 1 | 2025/5/26 |
5.8.14 | 2 | 2025/5/25 |
5.8.13 | 1 | 2025/5/26 |
5.8.12 | 1 | 2025/5/26 |
5.8.11 | 1 | 2025/5/27 |
5.8.10 | 1 | 2025/4/17 |
5.8.9 | 1 | 2025/4/17 |
5.8.8 | 1 | 2025/5/26 |
5.8.7 | 1 | 2025/5/26 |
5.8.6 | 3 | 2025/5/25 |
5.8.5 | 1 | 2025/5/30 |
5.8.4 | 1 | 2025/5/26 |
5.8.3 | 1 | 2025/5/26 |
5.8.2 | 1 | 2025/5/26 |
5.8.1 | 1 | 2025/5/26 |
5.8.0 | 1 | 2025/5/26 |
5.7.5 | 2 | 2025/5/26 |
5.7.4 | 1 | 2025/5/26 |
5.7.3 | 1 | 2025/5/30 |
5.7.2 | 2 | 2025/5/30 |
5.7.1 | 2 | 2025/5/26 |
5.7.0 | 1 | 2025/5/26 |
5.6.4 | 1 | 2025/5/26 |
5.6.3 | 1 | 2025/5/26 |
5.6.2 | 1 | 2025/5/26 |
5.6.1 | 2 | 2025/5/30 |
5.6.0 | 1 | 2025/5/26 |
5.5.5 | 1 | 2025/5/26 |
5.5.4 | 1 | 2025/5/26 |
5.5.3 | 1 | 2025/5/30 |
5.5.2 | 2 | 2025/5/26 |
5.5.1 | 1 | 2025/5/26 |
5.5.0 | 1 | 2025/5/26 |
5.4.2 | 2 | 2025/5/26 |
5.4.1 | 1 | 2025/5/26 |
5.4.0 | 1 | 2025/5/26 |
5.3.2 | 1 | 2025/5/30 |
5.3.1 | 1 | 2025/5/26 |
5.3.0 | 1 | 2025/5/30 |
5.2.1 | 2 | 2025/5/26 |
5.2.0 | 1 | 2025/5/26 |
5.1.2 | 1 | 2025/5/26 |
5.1.1 | 1 | 2025/5/26 |
5.1.0 | 2 | 2025/5/26 |
5.0.4 | 2 | 2025/5/26 |
5.0.3 | 1 | 2025/5/30 |
4.5.3.3 | 1 | 2025/5/26 |
4.5.3.2 | 2 | 2025/4/17 |
4.5.3.1 | 4 | 2025/5/25 |
4.5.3 | 2 | 2025/5/26 |
4.5.2.1 | 2 | 2025/5/26 |
4.5.2 | 1 | 2025/5/26 |
4.5.1 | 1 | 2025/5/26 |
4.1.1 | 1 | 2025/5/26 |
4.1.0 | 3 | 2025/5/24 |
4.0.5 | 1 | 2025/5/26 |
4.0.4 | 2 | 2025/4/27 |
4.0.3 | 2 | 2025/5/26 |
4.0.2 | 2 | 2025/5/26 |
4.0.1.1 | 1 | 2025/5/26 |