How to create a pivot table in c# using openxml?

See more:

C#

SharePoint2010

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.