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 : [email protected] 15000 AURILLAC Internet : http://www.qualiac.com<blocked::http://www.qualiac.com/> FRANCE P Avant d'imprimer ce mail pensez à l'environnement - Merci
