PivotTable: Refresh cache of PivotTable(s)

[mvanwaaijen]

As of now, you can only add a new pivot table with the AddPivotTable function and not reference an existing pivot table. I am looking for a way to refresh the cache of the pivottable for instance by calling a RefreshPivotTables() function or something like that to refresh the cache when the underlying data an existing pivot table has been changed...

[SVilgelm]

@xuri D you have any ideas how to refresh the pivot tables? I can implement it, but I need some hints where to start.
I really need this feature and will be glad if to get it in next release

[SVilgelm]

@mvanwaaijen Do you know any other go libraries, that can work with pivot tables?

I need to edit an excel file, that contains the pivot tables, and after the saving I would like to see the updated pivot tables.

[drsasa]

@SVilgelm For now you can have your templates checked 'Refresh data when opening the file'. That way when you save changed excel file through code, when you open it with Excel will be automatic refreshed.

[SVilgelm]

@drsasa thank you!

[mvanwaaijen]

@mvanwaaijen Do you know any other go libraries, that can work with pivot tables?

I need to edit an excel file, that contains the pivot tables, and after the saving I would like to see the updated pivot tables.

I see there is already a solution. I am not aware of any other packages that can do all this...