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