Excel Pivot table in ASP

Question

Is there a way I can create Excel Pivot tables using ASP .NET 3.5 with C# ?

Answer 1

I have done this using a third party product: Gembox professional.

Create an Excel spreadsheet with a Pivot table based on a named range. Export your data to the spreadsheet, update the name of the range and voila.

(I am not related to Gembox in any other way than being a happy customer)

Answer 2

Have a look at

• Worksheet.PivotTableWizard Method
• Creating a PivotTable Programmatically