Tables & Pivot Tables¶
EPPlus can create and change both Excel tables and pivot tables. Tables are created through the Tables property of the ExcelWorksheet class, and pivot tables through its PivotTables property.
Tables¶
- Tables - Add, change and delete tables, insert rows and columns, and export table data to a
DataTable. - Table filters and slicers - Filter table columns, with or without slicers.
- Built in Table styles - The 60 built-in table styles.
- Custom Table Styles - Create your own named table styles.
- Sorting tables - Sort the rows of a table.
- Working with DataRows - Work with the data rows of a table.
Pivot tables and pivot charts¶
- Pivot tables and pivot charts - Add pivot tables with row, column, page and data fields, and create pivot charts on them.
- Filters and slicers - Filter pivot tables, with or without slicers.
- Styling via pivot areas - Style specific parts of a pivot table.
- Custom pivot table styles - Create your own named pivot table styles.
- Sorting - Sort the fields and items of a pivot table.
- Expanding and collapsing Pivot Table items - Control which items are expanded or collapsed.
- Using the Data-field - ShowDataAs property - Show data field values as percentages, differences, running totals and similar.
- Calculating Pivot tables - Calculate pivot tables with EPPlus, without Excel.