Exception "Index was out of range. Must be non-negative and less than the size of the collection." is generating while load XLS file

Aspose.Cells Product Family
1

CP_Sample_1.zip (26.3 KB)

Dear Aspose Support Team,

While load shared XLS file by Aspose.Cells componet’s workbook object, it generate below exception.

Exception.Message : Index was out of range. Must be non-negative and less than the size of the collection. (Parameter ‘index’)
Exception.Source : System.Private.CoreLib
Exception.StackTrace : at .()
at .(ChartFrame , Boolean , Boolean )
at .()
at .(Byte[] , Int32 , MsoDrawingType )
at .()
at .( )
at .( )
at .( )
at .(Stream )
at .( , Stream )
at .( , Stream )
at .( , String )
at .(String , Stream , LoadOptions )
at Aspose.Cells.Workbook.(String , LoadOptions )

2

@casepoint.networkstaff
In fact there is some invalid data in the template file and ms excel also shows warning when opening it. Anyways, we will investigate it and try to handle the invalid data so that the file can be loaded without exception.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55827

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@casepoint.networkstaff,

This is to inform you that your issue (logged as “CELLSNET-55827”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.6) that we plan to release in the first half of June 2024. You will be notified when the new version is published.

4

The issues you have found earlier (filed as CELLSNET-55827) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi