Creating a pivot table in Excel using Open XML and C #

Question

I used a data warehouse in a DataTable and would like to create a pivot table using this data.

I read a lot of posts and also read the Microsoft documentation on creating a pivot table through Open XML, but could not get a solution. Can someone send some code to create a pivot table.

Thanks in advance.

Answer 1

Install the Open XML SDK , it contains a tool called the Open XML SDK Performance Tool.

How to use it:

Open Excel and create a file containing a pivot table. Save it and open it using the Performance tool. This tool has the option "Reflect the code", so you can see how to create the same Excel using C # code.