This page is no longer maintained. For the current list of EPPlus features, see https://epplussoftware.com/en/Developers/Features. The EPPlus documentation has moved to https://epplussoftware.com/docs/; please update your bookmarks.

For more details see our feature page at our web site, https://www.epplussoftware.com/en/Developers/Features

• [Support for 8 LAMBDA style functions](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/using-lambda-functions/)
• [Dynamic array formulas](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/dynamic-arrayformulas/)
• [Legacy array formulas](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/legacy-arrayformulas/)
• Implicit intersection
• Intersect operator.
• Better support for colon operator with functions.
• 307 new functions since EPPlus 4.

• [Newer VBA signatures](https://epplussoftware.com/docs/vba-and-protection/vba/#sign-your-vba-code), EPPlus now supports the Legacy, Agile and V3 signatures.
• Possibility to set the Hash Algorithm - MD5, SHA1, SHA256, SHA384 or SHA512.

• From EPPlus 6 EPPlus will use internal functionality that replaces System.Drawing.Common/libgdiplus on non windows platforms.

• Export html/css from worksheet ranges and tables

• Export json data from worksheet ranges and tables

• Value filters
• Date group filters
• Custom filters
• Top 10 filters
• Dynamic filters

• Filters
• Calculated columns
• Support for shared caches
• [Pivot table slicers](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-filters-and-slicers/)
• Create and modify custom pivot table styles
• [Style pivot tables using pivot areas](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-styling-via-pivot-areas/)
• [Sorting](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-sorting/)
• [Show Value As for data fields](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/data-field-showdataas/)
• [Pivot table calculation](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/calculating-pivot-tables/)

• [Filters and slicers](https://epplussoftware.com/docs/tables-and-pivot-tables/tables/table-filters-and-slicers/)
• [Sorting](https://epplussoftware.com/docs/tables-and-pivot-tables/tables/sorting-tables/)

• [Sorting enhancments](https://epplussoftware.com/docs/worksheet-and-ranges/range-operations/sorting-ranges/)
• Saving Range To Csv or a Data Table or map to a collection of T
  • [ExcelRange.ToText](https://epplussoftware.com/docs/import-export-data/export/totext/)
  • [ExcelRange.ToTextAsync](https://epplussoftware.com/docs/import-export-data/export/totext/)
  • [ExcelRange.SaveToText](https://epplussoftware.com/docs/import-export-data/export/savetotext/)
  • [ExcelRange.SaveToTextAsync](https://epplussoftware.com/docs/import-export-data/export/savetotext/)
  • [ExcelRange.ToDataTable](https://epplussoftware.com/docs/import-export-data/export/todatatable/)
  • [ExcelRange.ToCollection<T>](https://epplussoftware.com/docs/import-export-data/export/tocollection/)
• [Take and Skip column/rows from a range](https://epplussoftware.com/docs/worksheet-and-ranges/addressing/taking-and-skipping-columns-from-a-range/)

• Several new async functions
  • ExcelPackage.SaveAsync
  • ExcelPackage.SaveAsAsync
  • ExcelPackage.GetAsByteArrayAsync
  • ExcelPackage.LoadAsync
  • ExcelRange.LoadFromDataReaderAsync
  • ExcelRange.LoadFromTextAsync

• Creating and modifying theme properties.
• Loading and applying theme files (.thmx)

• New ColorManger, that adds support for theme colors, HSL colors, preset colors, rgb colors, rgb percentage colors and system colors. Also adds support for color transformations with effects like alpha, shade, hsl, rgb and more.
• New FillManager to support solid fills, gradient fills, pattern fills and blip fills.
• Support for numerous effects and 3D styling for drawing objects.
• Applying predefined glow, reflection, shadow and 3d effects

• Support for all Excel 2019 chart types, with 12 new types from EPPlus 5.2:
  • 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 & Whiskter Chart
  • Region Map Chart.
• New chart StyleManager to support over 100 Excel build-in style for all EPPlus supported chart types
• Loading and applying chart templates files (.crtx).
• Loading and applying chart style xml and color xml (can be extracted from a .xlsx package).
• New typed methods to add charts to the drawings collection. For example, AddPieChart or AddLineChart.
• New typed Series collection to more easily access chart specific typed series.
• Errorbars, High-Low lines, Drop lines and Up/Down bars
• New As property to the Drawing, ConditionalFormatting and Datavalidation objects for easier type cast. For example var sunburstChart = worksheet.Drawings[0].As.Chart.SunburstChart; or var listDv = sheet.DataValidations.First().As.ListValidation; *Support for adding Shapes and Pictures inside the chart.

• Support for ignoring errors on cell ranges

• See [this page](https://epplussoftware.com/docs/worksheet-and-ranges/cell-content/comments/threaded-comments/)

• See [this page](https://epplussoftware.com/docs/formulas-and-filters/external-links/)

• Table Slicers, see [Table filters and slicers](https://epplussoftware.com/docs/tables-and-pivot-tables/tables/table-filters-and-slicers/)
• Pivot Table Slicers, see [Filters and slicers](https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-filters-and-slicers/)

• [Dynamic array formulas](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/dynamic-arrayformulas/)
• [Legacy array formulas](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/legacy-arrayformulas/)
• Improved functionality for [circular references](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/circular-references/)
• More Excel compatible handling of floatnumbers/rounding, see [this page](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/#floating-point-precision)
• 307 new functions: See full list [here](https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/supported-functions/)

• See [this page](https://epplussoftware.com/docs/charts-and-drawing-objects/form-controls/)

• Create custom styles that can be applied to tables, pivot table or both from scratch or use a build in style as template.
• Create custom styles for slicers from scratch or use a build in style as template.
• See [this page](https://epplussoftware.com/docs/styling/working-with-custom-named-table-or-slicer-styles/)