EPPlus 4.0.2

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package EPPlus --version 4.0.2                
NuGet\Install-Package EPPlus -Version 4.0.2                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<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                
#r "nuget: EPPlus, 4.0.2"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install EPPlus as a Cake Addin
#addin nuget:?package=EPPlus&version=4.0.2

// Install EPPlus as a Cake Tool
#tool nuget:?package=EPPlus&version=4.0.2                

A library to manage Excel spreadsheets, using OOXML.

Product Compatible and additional computed target framework versions.
.NET Framework net20 is compatible.  net35 was computed.  net40 was computed.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (805)

Showing the top 5 NuGet packages that depend on EPPlus:

Package Downloads
iRely.Common

iRely.Common

UmbracoForms.Core

Umbraco Forms is an extension for Umbraco CMS allowing editors to create and manage forms and review submissions. The packages available from this feed can be used with Umbraco CMS versions up to version 8. For Umbraco CMS version 9, please use the feed available at https://www.nuget.org/packages/Umbraco.Forms/

Dynamicweb.Data

Data access API

Umbraco.Forms.Core.Providers

Umbraco Forms Core Providers encapsulates core providers of the forms builder for use by package developers.

EPPlus.Core.Extensions

An extensions library for EPPlus package to generate and manipulate Excel files easily.

GitHub repositories (61)

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

Repository Stars
ldqk/Masuit.Tools
全龄段友好的C#万能工具库,码数吐司库,包含一些常用的操作类,大都是静态类,加密解密,反射操作,权重随机筛选算法,分布式短id,表达式树,linq扩展,文件压缩,多线程下载,硬件信息,字符串扩展方法,日期时间扩展操作,中国农历,大文件拷贝,图像裁剪,验证码,断点续传,集合扩展、Excel导出等常用封装。诸多功能集一身,代码量不到2MB!
ivanpaulovich/clean-architecture-manga
:cyclone: Clean Architecture with .NET6, C#10 and React+Redux. Use cases as central organizing structure, completely testable, decoupled from frameworks
fullstackhero/blazor-starter-kit
Clean Architecture Template for Blazor WebAssembly Built with MudBlazor Components.
mini-software/MiniExcel
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
smartstore/SmartStoreNET
Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution
Version Downloads Last updated
7.4.2 81,460 10/28/2024
7.4.1 122,154 10/11/2024
7.4.0 109,633 10/2/2024
7.3.2 148,414 9/17/2024
7.3.1 139,701 9/5/2024
7.3.0 190,850 8/20/2024
7.2.2 373,539 7/24/2024
7.2.1 384,114 7/2/2024
7.2.0 240,455 6/18/2024
7.1.3 361,929 5/28/2024
7.1.2 610,964 4/23/2024
7.1.1 359,909 4/8/2024
7.1.0 166,967 3/28/2024
7.0.10 336,311 3/11/2024
7.0.9 548,927 2/15/2024
7.0.8 459,475 1/24/2024
7.0.7 91,431 1/19/2024
7.0.6 231,888 1/10/2024
7.0.5 313,008 12/22/2023
7.0.4 169,046 12/15/2023
7.0.3 268,167 12/5/2023
7.0.2 225,858 11/23/2023
7.0.1 281,576 11/9/2023
7.0.0 259,325 10/26/2023
6.2.19 142,288 3/27/2024
6.2.18 16,569 3/11/2024
6.2.17 10,410 2/15/2024
6.2.16 27,930 1/10/2024
6.2.15 42,920 12/15/2023
6.2.14 6,457 12/5/2023
6.2.13 6,947 11/23/2023
6.2.12 12,981 11/9/2023
6.2.11 46,470 10/26/2023
6.2.10 584,362 10/2/2023
6.2.9 466,487 9/8/2023
6.2.8 601,035 8/15/2023
6.2.7 511,932 7/19/2023
6.2.6 782,188 6/15/2023
6.2.5 21,943 6/14/2023
6.2.4 670,242 5/15/2023
6.2.3 318,832 5/2/2023
6.2.2 364,201 4/17/2023
6.2.1 208,012 4/6/2023
6.2.0 293,261 3/24/2023
6.1.3 822,522 2/24/2023
6.1.2 897,127 1/19/2023
6.1.1 1,297,148 11/21/2022
6.1.0 515,078 11/3/2022
6.0.8 1,183,200 9/21/2022
6.0.7 771,428 8/30/2022
6.0.6 1,320,497 7/8/2022
6.0.5 658,293 6/10/2022
6.0.4 659,234 5/12/2022
6.0.3 1,313,022 4/12/2022
5.8.14 546,602 9/21/2022
5.8.13 8,138 8/30/2022
5.8.12 86,710 7/8/2022
5.8.11 14,187 6/10/2022
5.8.10 44,302 5/12/2022
5.8.9 63,201 4/11/2022
5.8.8 481,117 3/22/2022
5.8.7 702,996 3/1/2022
5.8.6 607,137 2/3/2022
5.8.5 480,209 1/13/2022
5.8.4 709,138 12/14/2021
5.8.3 561,896 11/19/2021
5.8.2 521,229 10/29/2021
5.8.1 94,552 10/26/2021
5.8.0 173,564 10/21/2021
5.7.5 761,411 9/21/2021
5.7.4 580,505 8/26/2021
5.7.3 300,695 8/10/2021
5.7.2 548,610 7/22/2021
5.7.1 311,574 7/6/2021
5.7.0 589,675 6/17/2021
5.6.4 896,789 5/12/2021
5.6.3 822,000 4/16/2021
5.6.2 166,902 4/7/2021
5.6.1 409,223 3/22/2021
5.6.0 193,817 3/15/2021
5.5.5 534,002 2/23/2021
5.5.4 169,988 2/16/2021
5.5.3 777,450 2/3/2021
5.5.2 442,296 1/18/2021
5.5.1 160,469 1/12/2021
5.5.0 396,616 12/18/2020
5.4.2 701,191 11/19/2020
5.4.1 355,441 11/5/2020
5.4.0 631,543 10/8/2020
5.3.2 607,728 9/14/2020
5.3.1 228,157 9/2/2020
5.3.0 240,144 8/20/2020
5.2.1 573,046 7/22/2020
5.2.0 609,435 6/24/2020
5.1.2 728,009 5/13/2020
5.1.1 414,598 4/27/2020
5.1.0 510,253 4/7/2020
5.0.4 664,465 3/10/2020
5.0.3 349,234 3/8/2020
4.5.3.3 23,009,085 1/30/2020 4.5.3.3 is deprecated because it is no longer maintained.
4.5.3.2 17,200,821 6/16/2019 4.5.3.2 is deprecated because it is no longer maintained.
4.5.3.1 6,687,389 2/3/2019 4.5.3.1 is deprecated because it is no longer maintained.
4.5.3 1,706,852 1/6/2019 4.5.3 is deprecated because it is no longer maintained.
4.5.2.1 8,472,684 5/30/2018 4.5.2.1 is deprecated because it is no longer maintained.
4.5.2 440,925 5/24/2018 4.5.2 is deprecated because it is no longer maintained.
4.5.1 2,185,940 3/25/2018 4.5.1 is deprecated because it is no longer maintained.
4.1.1 3,540,982 10/8/2017 4.1.1 is deprecated because it is no longer maintained.
4.1.0 8,397,236 7/14/2016 4.1.0 is deprecated because it is no longer maintained.
4.0.5 2,762,043 1/8/2016 4.0.5 is deprecated because it is no longer maintained.
4.0.4 1,838,305 4/24/2015 4.0.4 is deprecated because it is no longer maintained.
4.0.3 681,544 2/12/2015 4.0.3 is deprecated because it is no longer maintained.
4.0.2 196,068 1/14/2015 4.0.2 is deprecated because it is no longer maintained.
4.0.1.1 253,914 11/30/2014 4.0.1.1 is deprecated because it is no longer maintained.

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