-
Notifications
You must be signed in to change notification settings - Fork 297
Pivot Tables
Mats Alm edited this page Jul 20, 2020
·
18 revisions
PivotTables can be created via the PivotTables property in the ExcelWorksheet class. Pivot charts are added as nomal charts via the AddChart method in the Drawings Collection as descibed here. The pivottable is added as argument three of this method.
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