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

Free Support Forum - aspose.com

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

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

@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.

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

Please find the attached template in ZIP

Excel_MS_1707.zip (49.4 KB)

@cagrawal_leva,

Thanks for the template XLSB file.

Pleaser try our latest version/fix: Aspose.Cells for Java v17.8:
https://downloads.aspose.com/cells/java/new-releases/aspose.cells-for-java-17.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.

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

Image20170821151907.jpg (100.9 KB)

@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.

@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

Hi,

You may get the latest version/fix: Aspose.Cells for Java v17.8 from maven repos. here:
http://maven.aspose.com/repository/simple/ext-release-local/com/aspose/aspose-cells/17.8/

Thank you.

@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.