Render PivotTable in GridDesktop

Possible Usage Scenarios

If your Excel file has a Pivot Table, GridDesktop will be able to load and render the Pivot Table fine. Besides, you will be able to interact the Pivot Table in GUI and manipulate it.

Render PivotTable in GridDesktop

The following sample code imports the Sample Excel File containing the Pivot Table. The screenshot shows the result of the execution of this sample code for a reference.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//Path of the sample Excel file containing Pivot Table
string filePath = Utils.Get_SourceDirectory() + "sampleRenderPivotTableInGridDesktop.xlsx";

//Import sample Excel file containing Pivot Table
this.gridDesktop1.ImportExcelFile(filePath);