Extract data from a Pivot Table

Aspose.Cells Product Family
1

Hi,


I’ve an Excel report generated by a department based in another country. It consists of one pivot table in one of the worksheets. The raw data on which this Pivot table is based on is in an access database for which I don’t have access to and neither will get.

Is there any way I could use Aspose.Cells to export all the data from this Pivot table into a new worksheet or dataset etc.?

Any code examples would be really helpful.

Regards,

Steve

2

Hi,

Thanks for considering Aspose.Cells for .NET.

Aspose.Cells allows you to access worksheet data. Since, your Pivot Table data is in Ms-Access database, so you will have to use Ole Ms-Access Data Reader to access your data.

You can search on internet how to access your Ms-Access data using C# and convert it into a DataTable or DataSet.

Once, you access your data from your database, you can then import the data into your worksheet.

Please see the following topic for your help.