blocks|key|1967158|text|您可以简单地激活一个选项，该选项将在每次打开文件时刷新透视表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1967159|此Microsoft+documentation表示：|offset|length|1967160|1967161|在“PivotTable选项”对话框的“数据”选项卡上，选中“打开文件时刷新数据”复选框。|blockquote|1967162|1967163|entityMap|0|LINK|mutability|MUTABLE|url|http://office.microsoft.com/en-au/excel-help/refresh-pivottable-data-HA101906071.aspx#_Toc270952720^0|0|1|N|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You can simple activate an option that will refresh the pivot table every time the file is opened.

This <a href="http://office.microsoft.com/en-au/excel-help/refresh-pivottable-data-HA101906071.aspx#_Toc270952720" rel="noreferrer">Microsoft documentation</a> says : 

<blockquote>
 In the PivotTable Options dialog box, on the Data tab, select the Refresh data when opening the file check box.
</blockquote>

blocks|key|4816077|text|这是可能的。在PivotCacheDefinition中，有一个可以设置为true的属性refreshOnLoad。然后，在打开工作簿时刷新缓存。More+information+here。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4816078|在POI中，这可以通过在CTPivotCacheDefinition上调用setRefreshOnLoad(boolean+bool)方法来完成，该方法接受一个布尔值作为参数。|4816079|编辑:+Apache+POI现在提供了创建数据透视表的可能性，并且数据透视表在加载时被默认刷新。Class+XSSFPivotTable|4816080|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.pivotcachedefinition.aspx|1|https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFPivotTable.html^0|7|K|11|4|18|D|21|L|0|0|11|U|0|1C|K|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@$9|10|A|11|1|12]]|E|$]]|$1|F|3|G|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]]|E|$]]|$1|J|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]|R|$5|M|N|O|E|$P|S]]]]

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

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

EDIT:
The Apache POI now provides the possibility to create pivot tables and the pivot table is refreshed on load as default. <a href="https://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFPivotTable.html" rel="nofollow">Class XSSFPivotTable</a>

blocks|key|61457|text|这篇文章说，你可以打开透视表上的一个选项，使它在每次打开工作簿时自动刷新：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|61458|How+can+I+refresh+all+the+pivot+tables+in+my+excel+workbook+with+a+macro?|offset|length|61459|希望在使用Apache+POI刷新或扩展数据透视表所基于的数据行之后，这仍然是正确的。|61460|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/70947/how-can-i-refresh-all-the-pivot-tables-in-my-excel-workbook-with-a-macro^0|0|0|21|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

This post says you can turn on an option on the pivot table that will cause it to refresh itself automatically every time the workbook is opened:

<a href="https://stackoverflow.com/questions/70947/how-can-i-refresh-all-the-pivot-tables-in-my-excel-workbook-with-a-macro">How can I refresh all the pivot tables in my excel workbook with a macro?</a>

Hopefully this will still be true after you have used Apache POI to refresh or extend the data rows on which the pivot tables are based.

blocks|key|2703104|text|这个问题的基本答案是否定的。POI是文档格式阅读器和编写器。更新数据透视表是一个excel引擎问题。当然，另一个应用程序可以尝试在这里复制Excel引擎行为，但这真的会变得很丑陋。我建议使用通过get服务访问excel+COM对象的Joel's解决方案来完成这类工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2703105|entityMap|0|LINK|mutability|MUTABLE|url|http://www.joelonsoftware.com/items/2008/02/19.html^0|38|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The basic answer to this is no. POI is a document format reader and writer. Updating the Pivot table is an excel engine issue. Sure, another application could try to duplicate the Excel engine behavior here, but that is really going to get ugly. I recommend using <a href="http://www.joelonsoftware.com/items/2008/02/19.html" rel="nofollow noreferrer">Joel's</a> workaround of accessing the excel COM objects over a webservice to get this kind of thing done.

blocks|key|61478|text|+protected+void+setRefreshPtOnLoad(boolean+refreshOnLoad){
++++++++List<POIXMLDocumentPart.RelationPart>+relationParts+=+((XSSFWorkbook)+workbook).getRelationParts();
++++++++for+(POIXMLDocumentPart.RelationPart+part+:+relationParts)+{
++++++++++++PackageRelationship+relationship+=+part.getRelationship();
++++++++++++if+(relationship.getRelationshipType().contains("pivotCacheDefinition")){
++++++++++++++++String+relationId+=+relationship.getId();
++++++++++++++++XSSFPivotCacheDefinition+cache+=+(XSSFPivotCacheDefinition)((XSSFWorkbook)+workbook).getRelationById(relationId);
++++++++++++++++CTPivotCacheDefinition+ctCache+=+cache.getCTPivotCacheDefinition();
++++++++++++++++ctCache.setRefreshOnLoad(refreshOnLoad);
++++++++++++++++break;+//+if+only+pivot+table+cache+exists+in+workbook,+else+-+remove+*break*
++++++++++++}
++++++++}
++++}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|61479|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> protected void setRefreshPtOnLoad(boolean refreshOnLoad){
 List&lt;POIXMLDocumentPart.RelationPart&gt; relationParts = ((XSSFWorkbook) workbook).getRelationParts();
 for (POIXMLDocumentPart.RelationPart part : relationParts) {
 PackageRelationship relationship = part.getRelationship();
 if (relationship.getRelationshipType().contains(&quot;pivotCacheDefinition&quot;)){
 String relationId = relationship.getId();
 XSSFPivotCacheDefinition cache = (XSSFPivotCacheDefinition)((XSSFWorkbook) workbook).getRelationById(relationId);
 CTPivotCacheDefinition ctCache = cache.getCTPivotCacheDefinition();
 ctCache.setRefreshOnLoad(refreshOnLoad);
 break; // if only pivot table cache exists in workbook, else - remove *break*
 }
 }
 }
</code></pre>

blocks|key|4816090|text|这可能会起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4816091|XSSFPivotTable+pivotTable+=+pivotSheet.getPivotTables().get(0);+++++
pivotTable.getPivotCacheDefinition().getCTPivotCacheDefinition().setRefreshOnLoad(true);|code-block|syntax|javascript|4816092|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This might work:

<pre><code>XSSFPivotTable pivotTable = pivotSheet.getPivotTables().get(0); 
pivotTable.getPivotCacheDefinition().getCTPivotCacheDefinition().setRefreshOnLoad(true);
</code></pre>

I'm currently working on a Java application that uses a template excel file that contains a pivot table. 

The template file also has a data sheet that seeds the pivot table. This data sheet is dynamically loaded in the java application through the Apache POI api. 

When I open the excel file I must refresh the Pivot table manually to get the data loaded correctly. 

Is there any way to refresh the Pivot table with the POI api so I don't have to manually do it?

Refresh Pivot Table with Apache POI

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我目前正在开发一个Java应用程序，它使用包含数据透视表的excel模板文件。模板文件还包含一个数据工作表，用于为数据透视表设定种子。该数据表通过Apache POI api动态加载到java应用程序中。打开excel文件时，必须手动刷新数据透视表，才能正确加载数据。有没有办法用POI api刷新透视表，这样我就不需要手动操作了？

问使用Apache POI刷新数据透视表
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Apache POI刷新数据透视表EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Apache POI刷新数据透视表
EN