Skip to content

Whats New

Mats Alm edited this page Dec 19, 2020 · 36 revisions

What is new in EPPlus 5

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

Filter support

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

Extended support for Pivot tables

Table Slicers

Saving Range To Csv or a Data Table

  • ExcelRange.ToText
  • ExcelRange.ToTextAsync
  • ExcelRange.SaveToText
  • ExcelRange.SaveToTextAsync
  • ExcelRange.ToDataTable

Async support

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

Theme support

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

Drawing enhancments

  • 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

Chart enhancments

  • 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;

Ignore Errors

  • Support for ignoring errors on cell ranges

Threaded Comments

Formula calculation

Form controls

EPPlus wiki

Versions

Worksheet & Ranges

Styling

Import/Export data

Formulas and filters

Charts & Drawing objects

Tables & Pivot Tables

VBA & Protection

Clone this wiki locally

⌂ 换网址