-4

I recently updated to this version and now I get the following error when I attempt to send my result set to Excel. I have updated appsettings.json as shown below the error message. I have gone to the EPPlus site and gone over the doc for setting the license.

ERROR Transparency.Components.Pages.VendorPayments.MoveNext [895] - MESSAGE: Error exporting to Excel: Please set the license using one of the methods on the static property ExcelPackage.License. See https://epplussoftware.com/developers/licensenotsetexception for more information
OfficeOpenXml.LicenseNotSetException: Please set the license using one of the methods on the static property ExcelPackage.License. See https://epplussoftware.com/developers/licensenotsetexception for more information

License entry in appsettings.json:

"EPPlus": {  
    "ExcelPackage": {  
        "LicenseContext": "NonCommercialOrganization:State of Florida"   
    }  
}

What am I missing?

Improve this question
3
  • I have updated appSettings.json as shown in the documentation and continue to get the error shown.
    – Brad G.
    Commented Apr 23 at 18:43
  • When you look at the page from EPPlus mentioned in the error message, the name of the inner most property needs to be just License - not LicenseContext
    – marc_s
    Commented Apr 23 at 18:52
  • 1
    Thank you marc_s! That is what I was missing.
    – Brad G.
    Commented Apr 24 at 12:02
Related questions
5
Trying to read excel file with epplus and getting System.NullException error?
2
EPPlus Dispose Doesn't Work
0
Export DataGridView into Excel using EPPlus Error property 'item' is 'read only'
Load 5 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.