Problem using PivotTables collection

Hello,

I'm an iseries programmer using the aspose java classes to create excel workbooks.

Most things work fine, but I can't use the PivotTables collection !!

Is there a problem with this class ?

Worksheet$getPivotTables seems to work ?

I can't retrieve a PivotTable from the collection (PivotTables$get), I can't add a PivotTable to the collection --> ClassCastException

Thanks,

Goddeau Hendrik

Hi,

Please check Creating a Simple PivotTable.

Which version do you use?

Thanks Warren.

I'm using a version of 9 february 2007.

I'm working as described.

For the data-source I'm using a "named range", is this a problem ?

Works fine when I use a datasource like 'Sheet1!A1:I60'

Hi,

You can use "Named Range" as the data source.