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)
精彩评论