# 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](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/index.md>) - Add, change and delete tables, insert rows and columns, and export table data to a `DataTable`.
- [Table filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/table-filters-and-slicers/index.md>) - Filter table columns, with or without slicers.
- [Built in Table styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/built-in-table-styles/index.md>) - The 60 built-in table styles.
- [Custom Table Styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/custom-table-styles/index.md>) - Create your own named table styles.
- [Sorting tables](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/sorting-tables/index.md>) - Sort the rows of a table.
- [Working with DataRows](<https://epplussoftware.com/docs/tables-and-pivot-tables/tables/working-with-datarows/index.md>) - Work with the data rows of a table.

### Pivot tables and pivot charts

- [Pivot tables and pivot charts](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/index.md>) - Add pivot tables with row, column, page and data fields, and create pivot charts on them.
- [Filters and slicers](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-filters-and-slicers/index.md>) - Filter pivot tables, with or without slicers.
- [Styling via pivot areas](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-styling-via-pivot-areas/index.md>) - Style specific parts of a pivot table.
- [Custom pivot table styles](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/custom-pivot-table-styles/index.md>) - Create your own named pivot table styles.
- [Sorting](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/pivot-table-sorting/index.md>) - Sort the fields and items of a pivot table.
- [Expanding and collapsing Pivot Table items](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/expanding-and-collapsing-pivot-table-items/index.md>) - Control which items are expanded or collapsed.
- [Using the Data-field - ShowDataAs property](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/data-field-showdataas/index.md>) - Show data field values as percentages, differences, running totals and similar.
- [Calculating Pivot tables](<https://epplussoftware.com/docs/tables-and-pivot-tables/pivot-tables/calculating-pivot-tables/index.md>) - Calculate pivot tables with EPPlus, without Excel.

### See also

- [Referencing tables in formulas](<https://epplussoftware.com/docs/formulas-and-filters/formula-calculation/referencing-tables-in-formulas/index.md>)
- [Working with custom named table- or slicer- styles](<https://epplussoftware.com/docs/styling/working-with-custom-named-table-or-slicer-styles/index.md>)
- [Working with slicers](<https://epplussoftware.com/docs/formulas-and-filters/working-with-slicers/index.md>)