Sheet to image rendering - an exception "java.lang.IllegalArgumentException: Invalid column index" is thrown

Aspose.Cells Product Family
1

Hello Aspose team,

I have the following error when I try to create a sheet render of my worksheet (Excel document is in attachment) :
java.lang.IllegalArgumentException: Invalid column index.

Used version : aspose-cells-16.11.0

Bellow my java code:

//New workbook with document
Workbook workbook = new Workbook(“C:\Temp\InvalidColumn.xlsx”);

//For each sheet
for (int i = 0; i<workbook.getWorksheets().getCount(); i++) {

//Get sheet
Worksheet worksheet = workbook.getWorksheets().get(i);

//Sheet render
ImageOrPrintOptions printOpts = new ImageOrPrintOptions();
**SheetRender sr = new SheetRender(worksheet, printOpts);**
}


Thank you, best Regards.

2

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue as per your description and logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-42097 - SheetRender - Invalid column index

3

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-42097 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
4
Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v16.11.10 and let us know your feedback.
5

The issues you have found earlier (filed as CELLSJAVA-42097) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
6

It works fine.

Thank you.

7
Hi,

Thanks for your feedback.

Good to know that your issue is sorted out by the new version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you