I have the following issue. I am trying to retrieve data from a pivot table. However when I run my test code to print out all data lines from the selected pivots some of the pivots selected will produce no data even tho data does exist in the workbook. I’ve noticed two things when trying to debug this issue:
For the file I’m trying to collect data from refreshing the pivot table doesn’t work. Instead i get the following error “Exception in thread “main” com.aspose.cells.CellsException: this data source is not supported.”.
It seems that if I manually change the pivots fields before parsing it so that all the pivots are set to all or to make sure the pivots are not being set to multiple items and having a few selected I can collect all the data. If one of the pivots is set to multiple items and has a few items selected only data for these selected pivots will be collected.
I’m not sure if 1 is related to 2. As in since refresh doesn’t work it means that when a pivot is set to multiple items it can’t collect any other pivot data unless its one of the selected.