We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Getting exception: Invalid sheet index - Please help!

Hi,

I am getting an exception when I am trying to save and then open a workbook using Aspose APIs. Below is the stack trace:

java.lang.IllegalArgumentException: Invalid sheet index: 65535
at com.aspose.cells.Worksheets.a(Unknown Source)
at com.aspose.cells.Worksheets.getSheet(Unknown Source)
at com.aspose.cells.ds.d(Unknown Source)
at com.aspose.cells.ds.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.open(Unknown Source)

I am using Aspose .Cells for Java. I am not able to simulate this issues because I get this error intermittently.

Can you please tell me when can I get this exception?

Thanks,
Malay

Hi,

Normally the exception occures when you try to specify incorrect index for a sheet or the code reaches to and there is an invalid sheet's index in the program. Well, we appreciate if you could create a sample test code to reproduce / simulate the error, then we may be in a better position to figure it out soon.

Thank you.

Hi Malay,

Which version of Aspose.Cells for Java are you using? Would you please try this latest version at:

https://forum.aspose.com/t/87401.

If the issue still persists, please give us your template file so we can trace it, thank you.

Hi Johnson,

We are using Aspose.Cells for Java v1.9.5.20 in our QA environment. As mentioned in the thread above, we are not able to replicate the error since it occurs around twice in a week. Out of the 100-150 jobs that we submit for generating Excel workbooks, the 2-3 jobs fail. We feel that during these jobs, there may be some API that we are calling which results in such an error.

Amjadā€™s response above says that we may be passing an invalid sheet index. But if you see the stack trace above, we are calling the workbook.open method on an existing .xls file created by Aspose. When we try reopening the same file through a standalone program, it works.

Since this exception is coming from the Aspose code, can you please provide us with pointers to get you a trace file that will help you in bug simulation. We will execute those steps in our QA environment here.

Thnaks,
Shashi

Hi Shashi,

Was the template file which be opened by Aspose.Cells and cause this issue an existed Excel file? Or it was dynamically created by your application with Aspose.Cells APIs too? If it was an existed file, I think you can send it to us so we can check and try to reproduce such issue, for safety, you can email it to me using the approach mentioned in http://www.aspose.com/corporate/purchase/faqs/send-license-to-aspose-staff.aspx . If it was dynamically created by your application, please check whethere your application creates it exactly same when it be opened successfully or with failure.

Another question, did the stack trace generated by Aspose.Cells for Java v1.9.5.20? It seems the trace did not coincide with this version. Anyway, if you can not provide the template file which cause this issue when open it, I am afraid there is no better way to trace it than adding some debug to try to trace more.

In this attached version, I have added some debug codes at the position where I think is the most possible place may cause such issue, if the program run into this debug block, there will be an log file named "AsposeDebug_SN" being created at the current path relative to you application. Wish we can get some more details if you use this version with your application so we can trace this issue, thank you.

Hi Johnson,

Our server environment uses JDK 1.4.x version. Can you please provide one for that version? I guess the attached Jar file is for JDK 1.5.

Thanks,
Shashi

Hi Shashi,

OK, we will soon provide you the debugging version compiled on JDK1.4 for your requirement.

Thank you.

Hi Shashi,

Please try this version for JDK1.4, thank you.