Problem using PivotTables collection

HGOAS4 · April 17, 2007, 1:49am

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

Warren · April 17, 2007, 2:39am

Hi,

Which version do you use?

HGOAS4 · April 17, 2007, 2:51am

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 ?

HGOAS4 · April 17, 2007, 3:35am

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

Warren · April 17, 2007, 4:07am

Hi,

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