We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Pivottable - Load data from Redordset or SqlCommand


Is it possible to load data into a Pivottable from a Recordset or SqlCommand instead of an excel range?



Thanks for your query.

Do you mean you have your source file which has existing pivot table whose source comes from some data source, e.g SQL Sever and later you manipulate pivot table? Please note, Aspose.Cells does not support to calculate a PivotTable whose data source is external (e.g SQL Server or external files). Moreover, if you have an Excel file containing such a pivot table in it, Aspose.Cells will keep/retain pivot table as it is (by loading it and saving it). Aspose.Cells supports to create pivot table and can perform all types of manipulations plus calculations if the data source is there in the file (Workbook).