-
Notifications
You must be signed in to change notification settings - Fork 297
Pivot Tables
Jan Källman edited this page Jan 27, 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 earlier. The pivottable is added as argument three of this method.
See Sample 18-.NET Framework or Sample 18-.NET Core
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