c# code to create pivot table in excel file

Mar 3 2014 6:22 AM
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