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