EPPlus 4.0.2

A library to manage Excel spreadsheets, using OOXML.

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

Release Notes

EPPlus 4.0.2

Visit epplus.codeplex.com for the latest information

EPPlus-Create Advanced Excel spreadsheet.

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

Release Candidare 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 cauesed corruption of the package
* Fixed a few Calculation when refering ranges (for example If)  function and some
* 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.

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 hanges if formula start with a parenthes.
* Worksheet.Dimension returned an invalid range in some cases.
* Rowheight was wrong in some cases.
* ExcelSeries.Header had an incorrect validation check.

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 inheritence
* And alot of other smal fixes

Dependencies

This package has no dependencies.

Showing the top 10 GitHub repositories that depend on EPPlus:

Repository Stars
nopSolutions/nopCommerce
Free open source ecommerce shopping cart (ASP.NET Core)
dotnetcore/DotnetSpider
DotnetSpider, a .NET Standard web crawling library. It is lightweight, efficient and fast high-level web crawling & scraping framework
smartstore/SmartStoreNET
Open Source ASP.NET MVC Ecommerce Shopping Cart Solution
Wyamio/Wyam
A modular static content and static site generator.
grandnode/grandnode
Free and Open Source Ecommerce Shopping Cart solution based on ASP.NET CORE and MongoDB
Far0n/xgbfi
XGBoost Feature Interactions & Importance
Necrobot-Private/NecroBot
NecroBot2
SharePoint/PnP-Tools
Scripts and tools for Office 365 and SharePoint - More for IT Pro's
libgenapps/LibgenDesktop
VahidN/PdfReport.Core
PdfReport.Core is a code first reporting engine, which is built on top of the iTextSharp.LGPLv2.Core and EPPlus.Core libraries

Version History

Version Downloads Last updated
4.5.3.2 635,912 6/16/2019
4.5.3.1 1,104,102 2/3/2019
4.5.3 254,068 1/6/2019
4.5.2.1 1,747,634 5/30/2018
4.5.2 57,366 5/24/2018
4.5.1 392,873 3/25/2018
4.5.0.3-rc 9,072 3/5/2018
4.5.0.2-rc 19,121 2/4/2018
4.5.0.1-beta 39,089 11/28/2017
4.5.0-beta 13,963 11/12/2017
4.1.1 1,181,728 10/8/2017
4.1.0 2,544,975 7/14/2016
4.0.5 1,002,224 1/8/2016
4.0.4 743,768 4/24/2015
4.0.3 155,558 2/12/2015
4.0.2 59,669 1/14/2015
4.0.1.1 58,858 11/30/2014
4.0.0-rc1 3,717 11/11/2014
4.0.0-beta2 18,864 4/18/2014
3.1.3.3 589,122 4/14/2013
3.1.3.2 6,173 4/14/2013
3.1.3 46,268 4/14/2013
3.1.2 67,378 11/6/2012
3.1.1 13,966 9/26/2012
3.1.0-beta 1,960 7/22/2012
3.0.0.2 56,293 2/1/2012
3.0.0.1 2,106 2/1/2012
2.9.0.1 12,750 6/2/2011
2.8.0.2 13,962 3/3/2011
Show less