• Pivot table enhancements.
  • Refresh pivot caches.
  • Calculate Pivot Tables.
  • Support for the GetPivotData function. EPPlus 7.2
  • Support for newer pivot table properties stored in the extLst element.
• Support for Conditional Formatting - Data bars and Icon Sets - in the HTML Export.
• Load and Save fixed-width text files.
• Transpose functionality in Load-, Save- and Copy functions

See the EPPlus 7.2 Project

• Redesign of the library into a modular architecture
• Improve test coverage
• Improve documentation & samples
• Performance improvements and new features.

See the EPPlus Epics project.

• ExcelRange.LoadFromCollection improvments.
• Support for Conditional Formatting in the HTML Export (except Data bars and Icon Sets).

• Improvements of the formula calculation engine.
  • Optimized tokenizer
  • Improved handling/performance of shared formulas.
  • Support for array formulas and dynamic array formulas.
  • Support for more functions.
• Conditional formatting
  • Improved performance.
  • Support for newer formats such as databars with gradient fill.

• New implementation of data validations.
  • Data validations will now be kept in-memory until the workbook is saved (Worksheet xml will not be updated in runtime).
  • Improved performance.
  • Better support for formulas referring to other worksheets.

• Support for newer VBA signatures - Agile and V3
• Added ExcelRangeBase.ToCollection to map ranges and tables to a collection of T.
• New methods for grouping Rows and Columns.

• Html/css & Json export.
• Remove dependency to System.Drawing.Common for Non GDI environments.

• Support for splitting panes in a worksheet.
• Better support for Row and Column properties (easier access via range, enumeration).
• Improved Range Copy support

• Support for 'Show data as' on pivot tables data fields.
• Support for External references in the formula parser.
• Enhanced sorting.

• Custom styles for Tables and Pivot Table and slicers
• Styling for tables.
• Pivot table styling via Pivot Areas

• Add support for Form controls like, buttons and checkboxes
• Export range to DataTable.

• Pivot Table Enhancements - Filters, Calculated Columns and Shared Caches
• Slicers

• Threaded comments
• Improve test coverage

• Add support for Extended chart types, like treemap, sunburst, histogram and more
• Improve documentation & samples
• Improve test coverage