-
Notifications
You must be signed in to change notification settings - Fork 297
Pivot Tables
Jan Källman edited this page Aug 27, 2019
·
18 revisions
...Work in Progress...
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 earlier. The pivottable is added as argument tree of this method.
See Sample 12.
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