A library to manage Excel spreadsheets, using OOXML.
See the version list below for details.
Install-Package EPPlus -Version 4.0.0-rc1
dotnet add package EPPlus --version 4.0.0-rc1
<PackageReference Include="EPPlus" Version="4.0.0-rc1" />
paket add EPPlus --version 4.0.0-rc1
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 the last pre-released version before the stable one. Please test and give us feedback. If no major bugs is found in this release, version 4 will be released before the end of this month.
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,
* 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 :)
*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
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 bugs, when refering ranges (for example in the If function)
* Added ChartAxis.DisplayUnit
* Fixed a bug related to shared formulas
* Named styles faild in some cases.
* Style.Indent got an invalid value in some cases.
* Fixed a problem with AutofitColumns method.
* Performance fix.
* An a whole lot of other small fixes.
This package has no dependencies.
Showing the top 10 GitHub repositories that depend on EPPlus:
The most popular open source ecommerce shopping cart solution based on ASP.NET Core
DotnetSpider, a .NET Standard web crawling library. It is lightweight, efficient and fast high-level web crawling & scraping framework
Open Source ASP.NET MVC Ecommerce Shopping Cart Solution
A modular static content and static site generator.
Free and Open Source Ecommerce Shopping Cart solution based on ASP.NET CORE and MongoDB
NetModular is a modular quickly develop solution for .Net Core and Vue.js.
XGBoost Feature Interactions & Importance
Scripts and tools for Office 365 and SharePoint - More for IT Pro's
Read more about the GitHub Usage information on our documentation.