Excel API Library for .NET - Sample Browser | Document Solutions | Pivot Table

## Pivot Table A Pivot Table is a data summarization tool. It can automatically count, total, or average the data stored in a spreadsheet, and display the resulting summarized data in a second table. Create a pivot cache using the **Create** method of the workbook's **PivotCaches** collection. It returns an instance of the **IPivotCache** interface. Create a Pivot Table using the **CreatePivotTable** method of the pivot cache instance. Or you can opt to use the **Add** method of the worksheet's **PivotTables** collection. Use the **PivotFieldOrientation** property of each pivot field to specify whether it is a RowField, ColumnField, ValueField, or PageField. // Save to an excel file workbook.Save("FolderExample.xlsx"); ' Create a new Workbook Dim workbook As New Workbook FIXME: This demo doesn't have VB code. ' save to an excel file workbook.Save("FolderExample.xlsx")