You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by maxime claux <m....@qualiac.com> on 2014/06/30 08:13:25 UTC

POI - Excel

Hello,

I'm a french developper, and I'm using Apache POI to refresh Excel Files.
But I don't understand how to create/update the refreshOnLoad property in my workbook to refresh the pivot tables when opening the file.


"It is possible. In the PivotCacheDefinition, there is an attribute refreshOnLoad that can be set totrue. The cache is then refreshed when the workbook is opened. More information here<http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.pivotcachedefinition.aspx>.

In POI this can be done by calling the method setRefreshOnLoad(boolean bool), that takes a boolean as parameter, on a CTPivotCacheDefinition."

http://stackoverflow.com/questions/1010673/refresh-pivot-table-with-apache-poi

Is there any issue ?

Thank you.

Maxime Claux.


Maxime CLAUX





Programmeur

Tél :

+ 33 4 71 64 60 26

QUALIAC®





Parc d'Activités de Tronquières





14 Avenue du Garric

e-mail :

m.claux@qualiac.com

15000 AURILLAC

Internet :

http://www.qualiac.com<blocked::http://www.qualiac.com/>

FRANCE











P Avant d'imprimer ce mail pensez à l'environnement - Merci