Issue with excel XLSB- XLSM formats

[cagrawal]

Hi

I tried to write data to xslm,xslb files. file internally has macros and pivot and charts.

when i used the blank xslm,xslb i am able to open the report properly without any issues after writing data.

but when i use the formatted base report (with charts, macros,formulas) after writing data and saving it and if i try to open it its showing a message that "file has unreadable content"

this is a high priority issue. Please provide the suggestions and solutions.

[Amjad_Sahi]

Hi,

Thanks for the template file.

I have tested your scenario/ case a bit using the following sample code with your template file (I opened and re-saved the file) using our latest version/fix Aspose.Cells for Java v8.0.2, it works fine. The output Excel file is opened fine into MS Excel.

e.g

Sample code:

Workbook workbook = new Workbook(“e:\test2\Current_Plan_Report_original.xlsm”);

workbook.save(“e:\test2\outCurrent_Plan_Report_original1.xlsm”, SaveFormat.XLSM);

Please try our latest version/fix: Aspose.Cells for Java 8.0.2 if it makes any difference. If you still find the issue, kindly provide us a sample code (runnable) on how do you insert data into the file to get the corrupted file, we will check it soon.

Thank you.