we are seeing below exception when reading excel files
IllegalStateException: toArray is not supported
at com.aspose.cells.b.a.d.zm.b()
at com.aspose.cells.a.a.zab.a(zm, boolean)
at com.aspose.cells.a.a.zz.d(String)
at com.aspose.cells.a.a.zz.c()
at com.aspose.cells.ztp.f()
at com.aspose.cells.ztp.(boolean)
at com.aspose.cells.zka.a(int, boolean)
at com.aspose.cells.zka.a(zm)
at com.aspose.cells.zka.a(String, zm, LoadOptions)
at com.aspose.cells.Workbook.a(String, LoadOptions)
at com.aspose.cells.Workbook.(String)
Can someone explain when and why we get this
Any solution to avoid the above exception
Thank you in advance.
Please zip and attach the template Excel file which we can use (for reading via Aspose.Cells APIs) to reproduce the issue. We will check your issue soon.
yeah we are using the above code as suggested and its working.
The problem not with reading the excel but about the above exception
That we are getting, it is not only happening with this sample
also happening with couple of other samples, I had the attached sample handy so kept it here.
Wanted to know the reason for that exception and any workaround to avoid that ?
@hruser,
Could you please share your sample file as it is not possible to reproduce this issue here with our sample files? It is not possible to exactly define the cases when this exception may raise however if you can share some sample file, we will look into it and share our feedback accordingly.