hi
i am refreshing the pivot tables in an excel and it has other language characters.
like chinese, spanish etc.
i am refreshing the excel pivot tables and saving the file with same name. its working for all other excels which dont have special charecters but with special charecters its not working.
sample code:
Workbook workbook = new Workbook(excelFileName);
int sheetCount = workbook.getWorksheets().getCount();
System.out.println(“sheet count…” + sheetCount);
for (int i = 0; i < sheetCount; i++) {
Worksheet ws = workbook.getWorksheets().get(i);
System.out.println(“worksheet name :”+ws.getName());
for (int k = 0; k < ws.getPivotTables().getCount(); k++) {
System.out.println(“in start…” + k);
ws.getPivotTables().get(k).setRefreshDataOnOpeningFile(true);
ws.getPivotTables().get(k).setRefreshDataFlag(true);
if (excelFileName.contains(“Extract”)) {
} else {
ws.getPivotTables().get(k).refreshData();
}
try {
ws.getPivotTables().get(k).calculateData(); //throwing outofbounds //error here
} catch (Exception el) {
el.printStackTrace();
}
ws.getPivotTables().get(k).setRefreshDataFlag(false);
}
}
workbook.save(excelFileName);
}catch(Exception e){
e.printStackTrace();
}
please provide the solution for this issue. i am using the latest aspose.jar(aspose-cells-7.4.3.1.jar)
thanks
Hi,
Here is the output console on my end:
sheet count..8
worksheet name :Sheet1
worksheet name :Plan of Record
in start..0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.aspose.cells.PivotFieldCollection.get(Unknown Source)
at com.aspose.cells.ais.a(Unknown Source)
at com.aspose.cells.ais.I(Unknown Source)
at com.aspose.cells.ais.a(Unknown Source)
at com.aspose.cells.PivotTable.calculateData(Unknown Source)
at PivotTableRefresh1.main(PivotTableRefresh1.java:30)
worksheet name :ReportCriteria
worksheet name :ReportPeriodMap
worksheet name :SWMETA2
worksheet name :SWMETA3
worksheet name :Queries
worksheet name :Ambassador_Data
The output file is also corrupted.
thanks amjad for quick reply.
This is an high priority issue for our client. Please look into this issue and provide me a solution as soon as possible.
thanks
Hi,
hi amjad any update on the issue?
Hi,
Hi Amjad
Do you have any update on this bug?
Thanks
Hi,
Thanks for your posting and using Aspose.Cells.
We are afraid, there is no update for you at this moment. However, we have logged your comment. Once, there is some update for you, we will let you know asap.
Hi thanks for the reply
ETA for this issue was before this week end. Any change in that ?
Thanks
Hi,
Please try the new fix/version: Aspose.Cells for Java v7.4.3.5.
The “outofbounds” issue is fixed in the latest fix/version: Aspose.Cells for Java v7.4.3.5.
Still the output file may not be correct, we will look into it further.
Thank you.
Hi
Thanks for the reply.
after updating the aspose jar file i found following observations:
1) column headers color ( if it is mixed color) aspose is not detecting that.
if it is straight color its working fine.
you can observe the excel (blue color) and generated pdf does not show up any thing(its blank).
if i change the color to straight color (red) its working fine.
2)some of the data in excel not appearing in pdf and some data is appearing incorrectly.
if you observe the current plan report sheet and at end of excel there are some rows but in generated pdf its showing "grand total " and blank values.
please analyze these issues and provide me fix.
Thanks
Hi,
hi
Thanks for the reply.
Can you provide me the ETA for the same.
Thanks
Hi,
Thanks for your posting and using Aspose.Cells.
Please spare us some time. Your issue is still under process. Once, there is some update for you, we will let you know asap.
Hi,
We have evaluated your issue a bit. I am afraid we could not support refreshing table formatting at the moment, we hope we could support it before the end of this month.
Thank you.
Hi,
The issues you have found earlier (filed as CELLSJAVA-40512) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.