Excel API Library for Java - Sample Browser | Document Solutions | Pivot Table
[
フレーム]
src="bundle.js">
## 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.
// Create a new workbook
Workbook workbook = new Workbook();null
// Save to an excel file
workbook.save("FolderExample.xlsx");
// Create a new workbook
var workbook = Workbook()
FIXME: No Kotlin code in this demo.
// Save to an excel file
workbook.save("FolderExample.xlsx")