Installation: Install EPPlus 6/7 from the EPPlus nuget feed.

As a holder of a commercial license, EPPlus 6/7 should be configured as described below - setting the value to Commercial.

EPPlus checks the LicenseContext only when a debugger is attached, so it is not necessary to have this set in a production environment when your code is compiled in Release mode.

The LicenceContext configuration parameter can be set in three different ways:

1. Use the LicenseContext property on the ExcelPackage class

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

using(var package = new ExcelPackage(new FileInfo("MyWorkbook.xlsx")))
{

}
            
        

2. appSettings.json

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

...or in the app.config...

            

<appSettings>
    <!--The license context used-->
    <add key="EPPlus:ExcelPackage.LicenseContext" value="Commercial" />
</appSettings>

            
            

3. Set the environment variable 'EPPlusLicenseContext'

This might be the easiest way of configuring this. Set the variable to Commercial

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