Free Support Forum - aspose.com

Xlsm (Macro-enabled Excel 2007) file generated by Aspose.Cells seems corrupted

I am getting the following error upon opening a xlsm file generated by Aspose.Cells.

"Excel cannot open the file 'template-out.xlsm' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

The following is my code to open and save the file:

WorkbookDesigner designer2007m = new WorkbookDesigner();
designer2007m.getWorkbook().open("C:\\temp\\TestProject\\data\\template.xlsm", FileFormatType.EXCEL2007);
designer2007m.setDataSource("MultiVariable",new String[] {"blah", "blah1"});
designer2007m.process(false);
designer2007m.save(new FileOutputStream("C:\\temp\\TestProject\\data\\template-out.xlsm"), FileFormatType.EXCEL2007);

I am also attaching my template and the file generated by Aspose.Cells for your reference.

- Jason

Hi Jason,

Thanks for the template files,

We will figure out the issue soon.

Thank you.

Hi Jason,

Currently Aspose.Cells for Java only supports the default file format-XLSX of Excel2007, for XLSM file format, we will look into it in later versions.

Johnson,

Thanks for the response. Do you have an approximate timeline for the support of XLSM format?

- Jason

Hi Jason,

I am afraid we can't give a definitive timeline for this feature currently, thank you for your patience