Pivot data source

Aspose.Cells Product Family
1

Hi,
does Aspose support excel pivot table creation using data source other than single range (MS Access, consolidated range [crossworksheet, crossworkbook], etc.)?
I’ve monitored pivot manual and last Aspose version API but found only single factory method to create pivot

pivotWorksheet.PivotTables.Add(source, “A1”, “PivotTable”);
where source is a range reference.

The problem is following:
create pivot table where source data size is more than 65536 rows (Excel 2003).

Please, advice.

Thanks.

2

Hi,

Thanks for your question.

Can you please provide me some sample Excel (xls/xlsx) document, in which Pivot Table was created using data sources other than ranges.

I think, it is a New Feature for Aspose.Cells. So I will log it after doing some investigation with your sample.

3

Sure,
attachment contains pivot table which is based on ms access db.
db is also attached.

Thanks!

4

Hi,

Thanks for your help and the files.

I think, it is a new feature, so I have logged it.

We will let you know by posting here, once it is available for you.

This issue has been logged as a New Feature Request with id: CELLSNET-26320.