This project is read-only.

Aspose.Cells - Create Pivot Table

PivotTableCollection pivotTables = sheet.getPivotTables();

//Adding a PivotTable to the worksheet
int index = pivotTables.add("=A1:C8","E3","PivotTable2");

//Accessing the instance of the newly added PivotTable
PivotTable pivotTable = pivotTables.get(index);

//Unshowing grand totals for rows.

//Dragging the first field to the row area.

//Dragging the second field to the column area.

//Dragging the third field to the data area.

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited May 9, 2014 at 5:24 AM by shoaibkhan, version 2