EPPlus 4.0.2
A library to manage Excel spreadsheets, using OOXML.
No packages depend on EPPlus.
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
This package has no dependencies.
Version | Downloads | Last updated |
---|---|---|
7.1.2 | 2 | 04/27/2024 |
7.1.1 | 2 | 04/12/2024 |
7.1.0 | 1 | 04/14/2024 |
7.0.10 | 3 | 03/13/2024 |
7.0.9 | 3 | 02/18/2024 |
7.0.8 | 2 | 01/24/2024 |
7.0.7 | 2 | 01/22/2024 |
7.0.6 | 3 | 01/12/2024 |
7.0.5 | 3 | 01/05/2024 |
7.0.4 | 2 | 12/15/2023 |
7.0.3 | 4 | 12/06/2023 |
7.0.2 | 3 | 11/29/2023 |
7.0.1 | 5 | 11/09/2023 |
7.0.0 | 3 | 10/26/2023 |
7.0.0-rc1 | 3 | 10/04/2023 |
7.0.0-preview2 | 11 | 07/21/2023 |
7.0.0-preview1 | 10 | 05/24/2023 |
7.0.0-beta1 | 4 | 09/25/2023 |
6.2.19 | 1 | 04/14/2024 |
6.2.18 | 2 | 03/13/2024 |
6.2.17 | 2 | 02/19/2024 |
6.2.16 | 4 | 01/13/2024 |
6.2.15 | 2 | 12/17/2023 |
6.2.14 | 6 | 12/06/2023 |
6.2.13 | 3 | 11/29/2023 |
6.2.12 | 7 | 11/09/2023 |
6.2.11 | 2 | 10/26/2023 |
6.2.10 | 5 | 10/04/2023 |
6.2.9 | 6 | 09/14/2023 |
6.2.8 | 7 | 09/14/2023 |
6.2.7 | 7 | 08/28/2023 |
6.2.6 | 5 | 06/18/2023 |
6.2.5 | 4 | 06/18/2023 |
6.2.4 | 8 | 05/17/2023 |
6.2.3 | 7 | 05/30/2023 |
6.2.2 | 5 | 06/18/2023 |
6.2.1 | 5 | 05/17/2023 |
6.2.0 | 5 | 06/18/2023 |
6.1.3 | 4 | 09/08/2023 |
6.1.2 | 4 | 05/17/2023 |
6.1.1 | 19 | 12/11/2022 |
6.1.0 | 15 | 11/30/2022 |
6.0.8 | 1,603 | 09/27/2022 |
6.0.7 | 13 | 09/09/2022 |
6.0.6 | 26 | 08/24/2022 |
6.0.5 | 10 | 09/02/2022 |
6.0.4 | 14 | 08/26/2022 |
6.0.3 | 14 | 06/30/2022 |
6.0.2-beta | 30 | 08/23/2022 |
6.0.1-beta | 10 | 07/25/2022 |
6.0.0-beta | 7 | 09/03/2022 |
5.8.14 | 10 | 06/18/2023 |
5.8.13 | 11 | 09/07/2022 |
5.8.12 | 20 | 08/04/2022 |
5.8.11 | 21 | 08/13/2022 |
5.8.10 | 15 | 08/13/2022 |
5.8.9 | 26 | 08/13/2022 |
5.8.8 | 10 | 08/13/2022 |
5.8.7 | 25 | 09/07/2022 |
5.8.6 | 21 | 06/30/2022 |
5.8.5 | 18 | 08/24/2022 |
5.8.4 | 9 | 08/25/2022 |
5.8.3 | 8 | 09/07/2022 |
5.8.2 | 13 | 09/02/2022 |
5.8.1 | 32 | 08/23/2022 |
5.8.0 | 34 | 07/25/2022 |
5.7.5 | 26 | 09/07/2022 |
5.7.4 | 14 | 09/02/2022 |
5.7.3 | 29 | 09/11/2022 |
5.7.2 | 29 | 09/07/2022 |
5.7.1 | 10 | 09/02/2022 |
5.7.0 | 11 | 08/25/2022 |
5.6.4 | 10 | 08/23/2022 |
5.6.3 | 10 | 08/23/2022 |
5.6.2 | 36 | 09/04/2022 |
5.6.1 | 9 | 09/02/2022 |
5.6.0 | 13 | 09/10/2022 |
5.5.5 | 18 | 07/13/2022 |
5.5.4 | 21 | 09/08/2022 |
5.5.3 | 27 | 09/07/2022 |
5.5.2 | 32 | 06/28/2022 |
5.5.1 | 7 | 09/05/2022 |
5.5.0 | 10 | 09/08/2022 |
5.4.2 | 12 | 08/23/2022 |
5.4.1 | 10 | 09/07/2022 |
5.4.0 | 35 | 09/10/2022 |
5.3.2 | 24 | 08/24/2022 |
5.3.1 | 10 | 08/13/2022 |
5.3.0 | 20 | 08/13/2022 |
5.2.1 | 18 | 07/01/2022 |
5.2.0 | 12 | 08/13/2022 |
5.1.2 | 9 | 08/19/2022 |
5.1.1 | 19 | 07/03/2022 |
5.1.0 | 12 | 07/25/2022 |
5.0.4 | 13 | 08/13/2022 |
5.0.3 | 14 | 08/13/2022 |
5.0.2-rc | 17 | 08/13/2022 |
5.0.1-beta | 17 | 08/13/2022 |
5.0.0-beta | 28 | 08/13/2022 |
4.5.3.3 | 1,814 | 06/27/2022 |
4.5.3.2 | 19 | 08/13/2022 |
4.5.3.1 | 30 | 08/13/2022 |
4.5.3 | 17 | 08/13/2022 |
4.5.2.1 | 27 | 08/13/2022 |
4.5.2 | 21 | 07/15/2022 |
4.5.1 | 24 | 08/13/2022 |
4.1.1 | 34 | 08/13/2022 |
4.1.0 | 28 | 07/03/2022 |
4.0.5 | 14 | 08/19/2022 |
4.0.4 | 9 | 08/19/2022 |
4.0.3 | 10 | 08/22/2022 |
4.0.2 | 10 | 08/18/2022 |
4.0.1.1 | 14 | 08/18/2022 |