EPPlus 6.0

Adds the ability to export a table or range to HTML/CSS.
April 13, 2022 - 9:41
New Version

Features

  • Added Microsoft .NET 6 support.
  • Added the ability to export a table or range to HTML/CSS.
  • Added the ability to export JSON directly from a range or a table. The .NET datatypes from EPPlus will be translated to a more generic format and both the raw value and the formatted value from the cells will be included. JSON export for ranges and table looks slightly different as tables contains a more structured format.
  • Removed direct reference to System.Drawing.Common.
  • Support for new image formats:
    • SVG.
    • ICO.
    • WebP.
  • Added 32 new functions:
    • BETADIST.
    • BETA.DIST.
    • BETAINV.
    • BETA.INV.
    • CHIDIST.
    • CHISQ.DIST.RT.
    • CHIINV.
    • CHISQ.INV.
    • CHISQ.INV.RT.
    • CORREL.
    • EXPONDIST.
    • EXPON.DIST.
    • FISHER.
    • FISHERINV.
    • FORECAST.
    • FORECAST.LINEAR.
    • GAUSS.
    • GEOMEAN.
    • HARMEAN.
    • INTERCEPT.
    • KURT.
    • PEARSON.
    • PHI.
    • RSQ.
    • SKEW.
    • SKEW.P.
    • STANDARDIZE.
    • ACCRINT.
    • ACCRINTM.
    • TBILLEQ.
    • TBILLPRICE.
    • TBILLYIELD.
  • Added new ExcelRangeBase.GetCellValue method.
  • Added new overload for ExcelRangeBase.LoadFromDictionaries method with IEnumerable.
  • Added Datatypes and Culture to LoadFromDictionariesParams. This is the settings for the ExcelRangeBase.ExcelRangeBase.LoadFromDictionaries.
  • Added ExcelRichTextCollection.HtmlText and ExcelRichText.HtmlText properties.
  • Added new parameter to ExcelAutoFilter.ApplyFilter to calculate formulas for the filter range.
EPPlus

EPPlus

Create, read and modify Office Open XML spreadsheets.

Got a Question?

Live Chat with our EPPlus Software licensing specialists now.