Importing New Google Spreadsheets

Aspose.Cells Product Family
1

Hi,


I have tried to read a New Google Spreadsheet(Spreadsheet created with Try the new Google Sheets enabled). First i will download the spreadsheet as a XLSX file and then try reading it.

I get the following error on creating the New Workbook on that file


caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
at java.util.ArrayList.rangeCheck(ArrayList.java:635)
at java.util.ArrayList.get(ArrayList.java:411)
at com.aspose.cells.lj.a(Unknown Source)
at com.aspose.cells.lj.c(Unknown Source)
at com.aspose.cells.lj.b(Unknown Source)
at com.aspose.cells.lo.q(Unknown Source)
at com.aspose.cells.lo.a(Unknown Source)
at com.aspose.cells.ln.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)


I have attached the downloaded xlsx file.

Please look into this. Im using the version 7.0.4


2

One More info :


I have downloaded the spreadsheet by choosing the type as application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

In case of old spreadsheet i have used application/x-vnd.oasis.opendocument.spreadsheet which works fine.

Is the type makes difference.

And the New Google spreadsheet does provide the option for choosing the type application/x-vnd.oasis.opendocument.spreadsheet
3

Any Update on this

4

Hi,


Please download and try our latest version/fix: Aspose.Cells for Java v7.7.0.3

I have used your file with it using the following sample code and it works fine. I can read and write your attached file. Please find the output file attached here for your reference.
e.g
Sample code:

String filePath = “40086313887426631884165155895867515001.xlsx”;
Workbook workbook = new Workbook(filePath);

workbook.save(“out_40086313887426631884165155895867515001.xlsx”);


Thank you.