Free Support Forum - aspose.com

Unreadable content after re-saving .xlsb in v8.5.1

Hi Aspose,


After merely re-saving an .xlsb file in Aspose.Cells for Java v8.5.1, Excel 2007 complains that it has “found unreadable content”, then another dialog box appeared saying “Excel was able to open the file by repairing or removing the unreadable content”.

Attached is the screenshot and .xlsb file to reproduce the issue.

// Open Excel file.
final Workbook workbook = new Workbook(“C:\Temp\QueryTableUnreadable.xlsb”);
// Save Excel file.
workbook.save(“C:\Temp\QueryTableUnreadable_out.xlsb”);

This problem does not occur if the file is .xlsm.

Please advise how we can resolve this issue.

Thanks.

Hi,

Thanks for your posting and using Aspose.Cells.

I have tested this issue with the following sample code using the latest version: Aspose.Cells
for Java v8.5.1.2
and found issue does not occur with the latest version and the output xlsb file opens fine in Microsoft Excel 2010.

I have attached the output xlsb file for your reference. Please remove its .txt extension after downloading it.

Java


String filePath = “F:\Shak-Data-RW\Downloads\QueryTableUnreadable.xlsb”;


Workbook workbook = new Workbook(filePath);

workbook.save(filePath + “.out.xlsb”);

Thanks. I have verified that it has been fixed in v8.5.1.2.

Hi Simon,


It is good to know that you are up & running again. Please feel free to contact us back in case you need our further assistance with Aspose APIs.