wxizhp/epplus

EPPlus-Excel spreadsheets for .NET

EPPlus 6

Announcement: new license model from version 5

EPPlus has from version 5 and up changed its license from LGPL to Polyform Noncommercial 1.0.0.

With the Polyform Noncommercial 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 EPPlus Software's website.

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>
    <!--The license context used-->
    <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

• All public references to System.Drawing.Common has been removed from EPPlus. See Breaking Changes in EPPlus 6.
• Static class 'FontSize' has splitted width and heights into two dictionaries. FontSizes are lazy-loaded when needed.
• ...and more, see https://epplussoftware.com/docs/6.0/articles/breakingchanges.html

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!

Nuget feed for latest builds

The latest builds from the EPPlus develop branch can be fetched from this Nuget feed