Excel Pivot table in ASP

Is there a way I can create开发者_如何转开发 Excel Pivot tables using ASP .NET 3.5 with C# ?

---

Have a look at

• Worksheet.PivotTableWizard Method
• Creating a PivotTable Programmatically

---

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)