Refreshing pivottable's datasource - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

Refreshing pivottable's datasource New

Mai Tri Thien

I using an excel template with pivot table (crosstab report).

In this example, https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-vb-net-create-excel-pivot-tables/114, I can not find any methods to perform an action like refreshing data of pivot table (I used named range like data source). I'm looking for an feature can be support in this case.

Comments (2)

Paolo

1 year ago

Has this feature been implemented?
I have same problem to refresh PivotTables already in an Excel file I'm feeding with data using GemBox. After finished to write new data I need to refresh PivotTables content.

Mario - GemBox

1 year ago

Hi,

Unfortunately no, this feature is still missing.

GemBox.Spreadsheet currently does not provide functionality to calculate the actual data of the Pivot Table.
Microsoft Excel application will refresh the Pivot Table when the output Excel file is opened.

Regards,

Mario
GemBox d.o.o.

Add a comment

Please log in or register to submit a comment.

Created By: Mai Tri Thien
First published: Apr 29, 2014