Unable to Read workbook using aspose java after MS Office 365 1707 update

Aspose.Cells Product Family
1

Hi team,

we have an issue with the aspose cells java post Microsoft’s Office 365 update.

The issue is with Update 1707, if we revert the 1707 version , the workbook object gets instantiated.

can you please help us in resolving this issue.

Thanks
Navneeth

2

@cagrawal_leva,

Thanks for your providing us some details.

Could you provide us template Excel file where Workbook object could not be instantiated, we will check it soon.

Thank you.

3

Hi @Amjad_Sahi : I am unable to upload the excel file since it is restricting me to upload (png,jpeg,pdf files).

Here is the stack trace of the exception. Can you please help me in uploading the excel file?

com.aspose.cells.CellsException: Invalid workbook setting in the xlsb workbook.
at com.aspose.cells.zcht.d(Unknown Source)
at com.aspose.cells.zcht.a(Unknown Source)
at com.aspose.cells.zcgk.e(Unknown Source)
at com.aspose.cells.zcgk.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)

Thanks
Navneeth

4

Please find the attached template in ZIP

5

Excel_MS_1707.zip (49.4 KB)

6

@cagrawal_leva,

Thanks for the template XLSB file.

Pleaser try our latest version/fix: Aspose.Cells for Java v17.8:

I have tested your scenario/case with it using the following sample code with your template XLSB file and it works fine. The output XLSX file is also fine tuned:
e.g
Sample code:

Workbook workbook = new Workbook("f:\\files\\Excel_MS_1707.xlsb");
workbook.save("f:\\files\\out1Excel_MS_1707.xlsx", SaveFormat.XLSX);

Thank you.

7

Hi @Amjad_Sahi,
I have tried by downloading the latest aspose version , but no luck.

Please find the below update from MS as a screen shot. This build number seems to have an issue.

Mean while i will check and update you the status.

Thanks

8

Image20170821151907.jpg (100.9 KB)

9

@cagrawal_leva,

Well, Aspose.Cells does not use or depend upon MS Office or its automation APIs. How it can be related to MS Office 365 update, please elaborate it. I could not reproduce the issue in a simple JAVA program on our end as it works fine (read your template file and save it as, etc.). We need to reproduce the issue on our end, so we could figure it out.

Thank you.

10

@Amjad_Sahi : Thanks for the info, we will be testing the latest jar and would provide an update.
Mean while can you please send me the Maven dependency for this version?

Thanks

11

Hi,

You may get the latest version/fix: Aspose.Cells for Java v17.8 from maven repos. here:

Thank you.

13

@101100,

Yes, every Java issue (including this one) is also fixed in Aspose.Cells for .NET respective version.

Let us know if you still find the issue with Aspose.Cells APIs.