Repository navigation
Whats New
Jan Källman edited this page Jun 17, 2021
·
36 revisions
For more details see our feature page at our web site, https://www.epplussoftware.com/en/Developers/Features
- Value filters
- Date group filters
- Custom filters
- Top 10 filters
- Dynamic filters
- Filters
- Calculated columns
- support for shared caches
- Pivot table slicers
- Create and modify custom pivot table styles
- Style pivot tables using pivot areas
- Sorting
- See this wiki page
ExcelRange.ToTextExcelRange.ToTextAsyncExcelRange.SaveToTextExcelRange.SaveToTextAsyncExcelRange.ToDataTable
- Several new async functions
ExcelPackage.SaveAsyncExcelPackage.SaveAsAsyncExcelPackage.GetAsByteArrayAsyncExcelPackage.LoadAsyncExcelRange.LoadFromDataReaderAsyncExcelRange.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
FillManagerto 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
StyleManagerto 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,
AddPieChartorAddLineChart. - New typed
Seriescollection to more easily access chart specific typed series. - Errorbars, High-Low lines, Drop lines and Up/Down bars
- New
Asproperty to the Drawing, ConditionalFormatting and Datavalidation objects for easier type cast. For examplevar sunburstChart = worksheet.Drawings[0].As.Chart.SunburstChart;orvar listDv = sheet.DataValidations.First().As.ListValidation;
- Support for ignoring errors on cell ranges
- See this wiki page
- Improved functionality for circular references
- More Excel compatible handling of floatnumbers/rounding, see this wiki page
- 128 new functions: See full list here
- See this wiki page
- 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 wiki page
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles
-
Formula Calculation
- Security considerations
- Circular references
- Referencing tables in formulas
- Supported Functions
- Dynamic array formulas
- Legacy array formulas
- Lambda functions
- Regression analysis functions
- Custom functions for calculations
- Function prefixes
- Precision as Displayed
- Cancelling a calculation
- Trim reference operator
- Working with filters
- Working with slicers
- Working with External Workbooks