c# code to create pivot table in excel file
Hi,
I have data in sql server table. I need to write a c# code to use this data and generate a pivot table in excel file.
Since there are around 52 columns in sql table, I am planing to create blank pivot table.
By this way, user can select any column from choose field list and generate his/her pivot table data.
Kindly help me in this issue.
Thanks
Rajneesh