EPPlus 4.0.0-beta2

A library to manage Excel spreadsheets, using OOXML.

This is a prerelease version of EPPlus.
There is a newer version of this package available.
See the version list below for details.
Install-Package EPPlus -Version 4.0.0-beta2
dotnet add package EPPlus --version 4.0.0-beta2
<PackageReference Include="EPPlus" Version="4.0.0-beta2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlus --version 4.0.0-beta2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

New cellstore, Formula calculation engine, Replaced EPPlus 4.0.0 Beta 2

Visit epplus.codeplex.com for the latest information

EPPlus-Create Advanced Excel spreadsheet.

This is a beta release. Please test and give us some feedback

New features

Replaced Packaging API with DotNetZip
* This will remove any problems with Isolated Storage and enable multi threading


New Cell store
* Less memory consumtion
* 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 :)

Perfomance
*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 bugfixes...

Beta 2 Changes
* Fixed bug when using RepeatColumns & RepeatRows at the same time.
* VBA project will be left untouched if its not accessed.
* Fixed problem with strings on save.
* Added locks to the cellstore for access by mulitple 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

Dependencies

This package has no dependencies.

NuGet packages (394)

Showing the top 5 NuGet packages that depend on EPPlus:

Package Downloads
iRely.Common
iRely.Common
UmbracoForms.Core
Umbraco Forms, the tool that makes creating contact forms, entry forms and questionnaires just as easy as using Word.
Xrm.Sdk.PluginRegistration
The Classic Microsoft Dynamics CRM tool, now in the XrmToolBox suite. This is special flavor of classical Plugin Registration Tool provided by Microsoft as CRM SDK code sample. It was adopted to the format of an XrmToolBox tool and intended to work with the same set of the Common Data Service / Dynamics 365 / CRM versions as supported by main application.
Ryr.XrmToolBox.ExportToExcel
Easily export records from the selected view/fetchxml to Excel.
Dynamicweb.Data
Dynamicweb 9 package that provides the data access API

GitHub repositories (22)

Showing the top 5 popular GitHub repositories that depend on EPPlus:

Repository Stars
nopSolutions/nopCommerce
The most popular open-source eCommerce shopping cart solution based on ASP.NET Core
smartstore/SmartStoreNET
Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution
iamoldli/NetModular
NetModular 是基于.Net Core 和 Vue.js 的业务模块化以及前后端分离的快速开发框架
ariacom/Seal-Report
Open Database Reporting Tool (.Net)
libgenapps/LibgenDesktop

Version History

Version Downloads Last updated
5.4.2 4,068 11/19/2020
5.4.1 23,580 11/5/2020
5.4.0 72,408 10/8/2020
5.3.2 84,609 9/14/2020
5.3.1 37,348 9/2/2020
5.3.0 45,668 8/20/2020
5.2.1 119,708 7/22/2020
5.2.0 108,333 6/24/2020
5.1.2 192,649 5/13/2020
5.1.1 105,628 4/27/2020
5.1.0 124,279 4/7/2020
5.0.4 260,627 3/10/2020
5.0.3 13,645 3/8/2020
5.0.2-rc 1,237 3/1/2020
5.0.1-beta 4,411 2/11/2020
5.0.0-beta 2,071 1/30/2020
4.5.3.3 1,659,268 1/30/2020
4.5.3.2 3,933,662 6/16/2019
4.5.3.1 2,432,458 2/3/2019
4.5.3 491,184 1/6/2019
4.5.2.1 3,167,479 5/30/2018
4.5.2 109,683 5/24/2018
4.5.1 659,828 3/25/2018
4.5.0.3-rc 10,337 3/5/2018
4.5.0.2-rc 24,691 2/4/2018
4.5.0.1-beta 50,794 11/28/2017
4.5.0-beta 18,720 11/12/2017
4.1.1 1,820,682 10/8/2017
4.1.0 3,594,673 7/14/2016
4.0.5 1,397,395 1/8/2016
4.0.4 988,478 4/24/2015
4.0.3 242,950 2/12/2015
4.0.2 82,863 1/14/2015
4.0.1.1 77,116 11/30/2014
4.0.0-rc1 4,446 11/11/2014
4.0.0-beta2 20,185 4/18/2014
3.1.3.3 805,994 4/14/2013
3.1.3.2 14,985 4/14/2013
3.1.3 67,043 4/14/2013
3.1.2 85,113 11/6/2012
3.1.1 16,881 9/26/2012
3.1.0-beta 2,418 7/22/2012
3.0.0.2 84,923 2/1/2012
3.0.0.1 2,816 2/1/2012
2.9.0.1 17,068 6/2/2011
2.8.0.2 16,419 3/3/2011
Show less