如何使用openxml在c＃中创建数据透视表？ [英] How to create a pivot table in c# using openxml?

问题描述

我想在另一个工作表中的表中创建一个名为pivot的工作表中的数据透视表。 excel文件位于SharePoint 2010的共享文档文档库中。到目前为止，我设法将数据写入文件，但无法使用openxml创建或刷新现有数据透视表。



我想通过获取现有数据透视表的实例并刷新它来刷新数据透视表，但这对我来说是不可能的。任何人都可以帮助我。我是openxml的新手。

I want to create a pivot table in a worksheet called pivot from a table which is in another worksheet. The excel File is in the shared documents document library in SharePoint 2010.so far i managed to write data into the file but couldn't create or refresh an existing pivot table using openxml.

I wanted to refresh the pivot table by getting the instance of the existing pivot table and refreshing it, but it was impossible to me. can any one help me please. I am new to openxml.

推荐答案

这篇关于如何使用openxml在c＃中创建数据透视表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！