HGOAS4
1
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
2
Hi,
Please check Creating a Simple PivotTable.
Which version do you use?
HGOAS4
3
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
4
Works fine when I use a datasource like 'Sheet1!A1:I60'
Warren
5
Hi,
You can use "Named Range" as the data source.