EPPlus 6.1.1

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
.NET 6.0 .NET Standard 2.0 .NET Framework 3.5
dotnet add package EPPlus --version 6.1.1
NuGet\Install-Package EPPlus -Version 6.1.1
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="6.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EPPlus --version 6.1.1
#r "nuget: EPPlus, 6.1.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. 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=6.1.1

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

EPPlus 6

Announcement: new license model from version 5

EPPlus has from this new major version changed license from LGPL to Polyform Noncommercial 1.0.0.

With the new license EPPlus is still free to use in some cases, but will require a commercial license to be used in a commercial business.

This is explained in more detail here.

Commercial licenses, which includes support, can be purchased at (https://www.epplussoftware.com/).

The source code of EPPlus has moved to a new github repository

LicenseContext parameter must be set

With the license change EPPlus has a new parameter that needs to be configured. If the LicenseContext is not set, EPPlus will throw a LicenseException (only in debug mode).

This is a simple configuration that can be set in a few alternative ways:

1. Via code

// If you are a commercial business and have
// purchased commercial licenses use the static property
// LicenseContext of the ExcelPackage class :
ExcelPackage.LicenseContext = LicenseContext.Commercial;

// If you use EPPlus in a noncommercial context
// according to the Polyform Noncommercial license:
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
    
using(var package = new ExcelPackage(new FileInfo("MyWorkbook.xlsx")))
{

}

2. Via appSettings.json

{
    {
    "EPPlus": {
        "ExcelPackage": {
            "LicenseContext": "Commercial" //The license context used
            }
        }
    }
}

3. Via app/web.config

<appSettings>
    
    <add key="EPPlus:ExcelPackage.LicenseContext" value="NonCommercial" />
</appSettings>

4. Set the environment variable 'EPPlusLicenseContext'

This might be the easiest way of configuring this. Just as above, set the variable to Commercial or NonCommercial depending on your usage.

Important! The environment variable should be set at the user or process level.

New features in EPPlus 6

EPPlus 6 comes with a set of new features, see (https://www.epplussoftware.com/Developers/Features)

Breaking Changes

Breaking Changes in version 5.

  • The default behavior for the Worksheet collection base in .NET Framework has changed from 1 to 0. This is the same default behavior as in .NET core today.
  • Pictures have changed the behavior as the oneCellAnchor tag is used instead of the twoCellAnchor tag with the editAs="oneCell".

Improved documentation

EPPlus 6 has a new web sample site available here: (https://samples.epplussoftware.com/) , Source code is available here: EPPlus.WebSamples There is also a new sample project for four different docker images, EPPlus.DockerSample EPPlus also has two separate sample projects for .NET Core and .NET Framework respectively. There is also an updated developer wiki. The work with improving the documentation will continue, feedback is highly appreciated!

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net35 net40 net403 net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (626)

Showing the top 5 NuGet packages that depend on EPPlus:

Package Downloads
UmbracoForms.Core The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

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/

iRely.Common

iRely.Common

Dynamicweb.Data

Data access API

CG.SharedEntities

Package Description

EPPlus.Core.Extensions

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

GitHub repositories (38)

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

Repository Stars
egametang/ET
Unity3D Client And C# Server Framework
ldqk/Masuit.Tools
包含一些常用的操作类,大都是静态类,加密解密,反射操作,权重随机筛选算法,分布式短id,表达式树,linq扩展,文件压缩,多线程下载和FTP客户端,硬件信息,字符串扩展方法,日期时间扩展操作,中国农历,大文件拷贝,图像裁剪,验证码,断点续传,集合扩展、Excel导出等常用封装。诸多功能集一身,代码量不到2MB!
blazorhero/CleanArchitecture
Clean Architecture Template for Blazor WebAssembly Built with MudBlazor Components.
smartstore/SmartStoreNET
Open Source ASP.NET MVC Enterprise eCommerce Shopping Cart Solution
DGP-Studio/Snap.Genshin
你想要的原神全家桶
Version Downloads Last updated
6.1.1 23,657 11/21/2022
6.1.0 66,165 11/3/2022
6.0.8 226,468 9/21/2022
6.0.7 149,788 8/30/2022
6.0.6 390,553 7/8/2022
6.0.5 211,215 6/10/2022
6.0.4 247,038 5/12/2022
6.0.3 349,647 4/12/2022
6.0.2-beta 3,664 3/24/2022
6.0.1-beta 7,775 3/10/2022
6.0.0-beta 8,987 3/7/2022
5.8.14 19,599 9/21/2022
5.8.13 3,129 8/30/2022
5.8.12 18,203 7/8/2022
5.8.11 6,616 6/10/2022
5.8.10 11,562 5/12/2022
5.8.9 25,182 4/11/2022
5.8.8 212,696 3/22/2022
5.8.7 333,582 3/1/2022
5.8.6 249,724 2/3/2022
5.8.5 207,865 1/13/2022
5.8.4 348,162 12/14/2021
5.8.3 262,650 11/19/2021
5.8.2 272,799 10/29/2021
5.8.1 49,183 10/26/2021
5.8.0 64,458 10/21/2021
5.7.5 403,245 9/21/2021
5.7.4 303,402 8/26/2021
5.7.3 162,431 8/10/2021
5.7.2 258,535 7/22/2021
5.7.1 172,282 7/6/2021
5.7.0 308,997 6/17/2021
5.6.4 638,967 5/12/2021
5.6.3 409,809 4/16/2021
5.6.2 104,384 4/7/2021
5.6.1 236,537 3/22/2021
5.6.0 120,928 3/15/2021
5.5.5 357,214 2/23/2021
5.5.4 107,135 2/16/2021
5.5.3 157,749 2/3/2021
5.5.2 240,869 1/18/2021
5.5.1 88,949 1/12/2021
5.5.0 267,230 12/18/2020
5.4.2 403,384 11/19/2020
5.4.1 216,589 11/5/2020
5.4.0 414,096 10/8/2020
5.3.2 406,060 9/14/2020
5.3.1 155,553 9/2/2020
5.3.0 161,265 8/20/2020
5.2.1 419,407 7/22/2020
5.2.0 434,066 6/24/2020
5.1.2 529,911 5/13/2020
5.1.1 251,105 4/27/2020
5.1.0 390,669 4/7/2020
5.0.4 508,544 3/10/2020
5.0.3 88,116 3/8/2020
5.0.2-rc 1,813 3/1/2020
5.0.1-beta 5,209 2/11/2020
5.0.0-beta 3,745 1/30/2020
4.5.3.3 10,557,445 1/30/2020
4.5.3.2 9,443,856 6/16/2019
4.5.3.1 4,706,067 2/3/2019
4.5.3 1,105,295 1/6/2019
4.5.2.1 6,003,558 5/30/2018
4.5.2 266,216 5/24/2018
4.5.1 1,339,785 3/25/2018
4.1.1 2,779,192 10/8/2017
4.1.0 5,775,311 7/14/2016
4.0.5 2,189,913 1/8/2016
4.0.4 1,408,495 4/24/2015
4.0.3 483,940 2/12/2015
4.0.2 150,428 1/14/2015
4.0.1.1 134,217 11/30/2014

EPPlus 6.1.1

IMPORTANT NOTICE!
From version 5 EPPlus changes the license model using a dual license, Polyform Non Commercial / Commercial license.
EPPlus will still have the source available, but for non Polyform NC compliant projects, EPPlus will provide a commercial license.
Commercial licenses can be purchased from https://epplussoftware.com/
This applies to EPPlus version 5 and later. Earlier versions are still licensed LGPL.

## Version 6.1.1
* Added Target framework .NET 7.
* Add support for linking a cell to a chart title text
* Bug fixes. https://epplussoftware.com/Developers/MinorFeaturesAndIssues

## Version 6.1.0
* Support for the Agile and V3 VBA signing. - https://github.com/EPPlusSoftware/EPPlus/wiki/VBA
* ExcelRange.ToCollection method - to map ranges and tables to an collection of T - https://github.com/EPPlusSoftware/EPPlus/wiki/ToCollection
* New methods to group, ungroup, collapse and expand rows and columns - https://github.com/EPPlusSoftware/EPPlus/wiki/Grouping-and-Ungrouping-Rows-and-Columns
* New overloads of Drawings.AddPicture that reads the signature of the image from stream to identify the type of image.
* AddPicture(string, Stream)
* AddPicture(string, Stream, Uri)
These overloads has been has been deprecated
* AddPicture(string, Stream, ePictureType)
* AddPicture(string, Stream, ePictureType, Uri)
* Preserve the 'Table' formula properties (Created via the What-If analysis-Data Table).
* Target framework .NET 5.0 has been removed as it is out of support by Microsoft.
* Bug fixes.

## Version 6.0.8
* Bug fixes.

## Version 6.0.7
* Minor feature and Bug fixes.

## Version 6.0.6
* Bug fixes.

## Version 6.0.5
* Bug fixes.

## Version 6.0.4
* Bug fixes.

## Version 6.0.3
* Html Export - https://github.com/EPPlusSoftware/EPPlus/wiki/HTML-Export
* Json Export - https://github.com/EPPlusSoftware/EPPlus/wiki/JSON-Export
* 32 new functions.
* Support for new image types: Svg, WebP and Ico.
* Removed direct references to System.Drawing.Common, see https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-6
* Bug fixes.

To see the new export in action, visit our new Web Sample Site: https://samples.epplussoftware.com/

See https://epplussoftware.com/Developers/EPPlus6 for more details.

## Version 5.8.10
* Bug fixes.

## Version 5.8.9
* Bug fixes.

## Version 5.8.8
* Bug fixes.

## Version 5.8.7
* Bug fixes.

## Version 5.8.6
* Bug fixes.

## Version 5.8.5
* Bug fixes.

## Version 5.8.4
* 10 new functions
* Bug fixes.

## Version 5.8.3
* Bug fixes.

## Version 5.8.2
* Bug fixes.

## Version 5.8.1
* Bug fixes.

## Version 5.8.0
* ExcelWorksheetView.SplitPanes method added
* ExcelRangeBase Fill method added
*   FillNumber
*   FillDateTime
*   FillList
* New collection properties for Rows and Columns
*   ExcelWorksheet.Rows
*   ExcelWorksheet.Columns
*   ExcelRangeBase.EntireRow
*   ExcelRangeBase.EntireColum
* Support for formatting and deleting individual Chart Legend Entries.
* Range.Copy improvments.
* Bug fixes

## Version 5.7.5
* Bug fixes.

## Version 5.7.4
* Bug fixes.

## Version 5.7.3
* Bug fixes.

## Version 5.7.2
* Bug fixes.

## Version 5.7.1
* Bug fixes.

## Version 5.7.0
* External links
* Enhanced sorting
* Table and auto filter sort state.
* Horizontal sorting
* Pivot table auto sort
* Pivot tables - Support for Show Value As on data fields
* Bug fixes.

## Version 5.6.4
* Bug fixes.

## Version 5.6.3
* Bug fixes.

## Version 5.6.2
* Bug fixes.

## Version 5.6.1
* Bug fixes.

## Version 5.6.0
* Custom table styles.
*   Create and modify custom table styles that can be applied to tables and pivot tables.
*   Create and modify custom slicer styles
* Pivot table styling using pivot areas to style individual areas within a pivot table.
* Enhanced table styling
* Added three new style properties to the ExcelTable and ExcelTableColumn
*   HeaderRowStyle
*   DataStyle
*   TotalsRowStyle
* Bug fixes.

## Version 5.5.5
* Bug fixes.

## Version 5.5.4
* Bug fixes.

## Version 5.5.3
* Bug fixes.

## Version 5.5.2
* Bug fixes.

## Version 5.5.1
* 10 new functions
* Bug fixes.

## Version 5.5.0
* Form Controls
*   Buttons
*   Drop-Downs
*   List Boxes
*   Check Boxes
*   Radio Buttons
*   Spin Buttons
*   Scroll Bars
*   Labels
*   Group Boxes
* Group/Ungroup drawing object via the ExcelDrawing.Group and ExcelDrawing.Ungroup methods
* New attribute support for LoadFromCollection. See https://github.com/EPPlusSoftware/EPPlus/wiki/LoadFromCollection-using-Attributes
* 20 new functions
* Bug fixes

## Version 5.4.2
* .NET 5.0
* Bug fixes

## Version 5.4.1
# Features
* WriteProtection added to Workbook.Protection. Allows to set a workbook to read-only with a password.
* ToDataTable method added to ExcelRange
* Bug fixes

## Version 5.4.0
### Features
* Pivot tables filters
*   Item filters - Filters on individual items in row/column or page fields.
*   Caption filters (label filters) - Filters for text on row and column fields.
*   Date, numeric and string filters - Filters using various operators such as Equals, NotBetween, GreaterThan, etc.
*   Top 10 filters - Filters using top or bottom criterias for percent, count or value.
*   Dynamic filters - Filters using various date- and average criterias.
* Add calculated fields to pivot tables.
* Support for pivot table shared caches via the new overload for PivotTables.Add.
* Support for pivot table slicers
* Support for table slicers

* Bug fixes

## Version 5.3.2
* Bug fixes

## Version 5.3.1
* Added support for copying threaded comments
* Add FormulaParserManager.Parse method.
* Bug fixes

New features in version 5.3.0:
* Support for Threaded Comments with mentions. See https://github.com/EPPlusSoftware/EPPlus/wiki/Threaded-comments
* New functions MAXIFS and MINIFS
* Bug fixes

New features in version 5.2.1:
* New method ExcelRange.LoadFromDictionary. Support for Dynamics in LoadFromCollection (ExpandoObject).
* Zip64 support in packaging to enable larger packages.
* Bug fixes.

New features in version 5.2:

* Support for extended chart types and stock charts:
* Four types of stock charts: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close and Volume-Open-High-Low-Close
* Sunburst Chart
* Treemap Chart
* Histogram Chart
* Pareto Chart
* Funnel Chart
* Waterfall Chart
* Box & Whisker Chart
* Region Map Chart.
* Support for 49 new functions in the formula calc engine, mainly finance and engineering.
* Bug fixes

New features in version 5.0 and 5.1:
* Extensively improved chart and drawing functionality/styling
* Theme support
* Filter support
* Async / Await support for I/O operations
* Ignore Error on cells
* Improvements of the formula calc engine and over 100 new supported functions
* Refactored/improved codebase
* Insert/Delete in ranges and tables.

Breaking Changes
* LoadFromCollection changes the data type of parameter 'TableStyle' from 'TableStyles' to 'TableStyles?'. The default value, if omitted, changes from 'TableStyles.None' to null. 'TableStyles.None', if supplied will create a table with style None.
* The default behavior for the Worksheet collection base in .NET Framework has changed from 1 to 0. This is the same default behavior as in .NET core today.
* Pictures have changed the behavior as the oneCellAnchor tag is used instead of the twoCellAnchor tag with the editAs="oneCell".
* Pivot tables will always refresh on load.
* Adding and inserting table row will now copy styles from the row above.
* ...and more, see https://epplussoftware.com/docs/5.8/articles/breakingchanges.html

Worksheets collection behavior in .NET Framework
The default behavior for the Worksheet collection base in .NET Framework has changed from 1 to 0. This is the same behavior as in .NET Core.
For backward compatibility the property IsWorksheets1Based can be set to true, to have the same behavior as in previous version of EPPlus. This property can also be set in the app.config.
For more details see https://github.com/EPPlusSoftware/EPPlus/wiki/Breaking-Changes-in-EPPlus-5.0
A list of fixed issues can be found here https://epplussoftware.com/docs/5.8/articles/fixedissues.html

Version history
6.1.1 20221121 Minor bug fixes. See https://epplussoftware.com/Developers/MinorFeaturesAndIssues
6.1.0 20221103 Newer types of VBA signatures, ToCollection method, Methods for Grouping rows and columns.
6.0.8 20220921 Minor bug fixes.
5.8.14 20220921 Minor bug fixes.
6.0.7 20220830 Minor bug fixes.
5.8.13 20220830 Minor bug fixes.
6.0.6 20220708 Minor bug fixes.
5.8.12 20220708 Minor bug fixes.
6.0.5 20220610 Minor bug fixes.
5.8.11 20220610 Minor bug fixes.
6.0.4 20220512 Minor bug fixes.
5.8.10 20220512 Minor bug fixes.
6.0.3 20220412 Html and JSON export. New drawing handling. https://epplussoftware.com/Developers/EPPlus6
5.8.9 20220411 Minor bug fixes.
5.8.8 20220322 Minor bug fixes.
6.0.1 20220310 Beta 2
6.0.0 20220307 Beta 1
5.8.7 20220301 Minor bug fixes.
5.8.6 20220203 Minor bug fixes.
5.8.5 20220113 Minor features and bug fixes.
5.8.4 20211214 Minor features and bug fixes.
5.8.3 20211119 Minor bug fixes.
5.8.2 20211029 Minor bug fixes.
5.8.1 20211026 Minor bug fixes.
5.8.0 20211021 Range.Fill methods, Range Rows and Column Collection, Range.Copy improvments and Worksheet Split Panes.
5.7.5 20210921 Minor bug fixes.
5.7.4 20210826 Minor bug fixes.
5.7.3 20210810 Minor bug fixes.
5.7.2 20210722 Minor bug fixes.
5.7.1 20210706 Minor bug fixes.
5.7.0 20210617 External links. Better sorting support. Pivot table ShowAs
5.6.4 20210512 Minor bug fixes.
5.6.3 20210416 Minor bug fixes.
5.6.2 20210407 Minor bug fixes.
5.6.1 20210322 Minor bug fixes.
5.6.0 20210315 Custom table styles. Pivot table styling. Table styling enhancements.
5.5.5 20210223 Minor bug fixes.
5.5.4 20210216 Minor bug fixes.
5.5.3 20210206 Minor bug fixes.
5.5.2 20210118 Minor bug fixes.
5.5.1 20210111 Minor features and bug fixes.
5.5.0 20201218 Form Controls.
5.4.2 20201119 Minor features and bug fixes.
5.4.1 20201105 Minor features and bug fixes.
5.4.0 20201008 Table- and Pivot Table- Slicers. Pivot Table Filters.
5.3.2 20200914 Bug fixes.
5.3.1 20200902 Minor features and bug fixes.
5.3.0 20200819 Support for threaded comment with mentions. Minor feature and bug fixes.
5.2.1 20200722 Minor features and bug fixes.
5.2.0 20200623 Support for 12 new chart types. Minor features and bug fixes.
5.1.2 20200513 Minor features and bug fixes.
5.1.1 20200427 Minor bug fixes.
5.1.0 20200401 Insert, Delete in Ranges and Tables. Minor bug fixes.
5.0.4 20200310 Minor bug fixes.
5.0.3 20200308 Initial release EPPlus 5