Aspose cells smart markers - Merged file corrupted for xlsx

Aspose.Cells Product Family
1

Hi

We have the licensed version of Aspose Total.(Aspose.Cells for Java V2.0.0 New Release and Aspose.Words for Java 2.6.0). We are using the Aspose cells smart markers for excel merge. For xlsx file format, the merged file is corrupted. Does this version of Aspose cells support xlsx format for smart markers.

Regards

Rachel

2

Hi Rachel,

Yes, it does support MS Excel 2007 Xlsx file format, could you give us more details and post your sample code with template files, we will check it soon.

Thank you.

3

Hi

Please find the sample code to reproduce the issue with xlsx. I have attached the excel templete, the merged file and the java code.

Regards

Rachel

4

Hi Rachel,

Thank you for considering Aspose.

Well, the smart markers are working fine. Actually, the issue is, you are not providing the FileFormatType while saving the file in Excel 2007 file format. Please change your save method to designer.save(“d:/MergedExcelx.xlsx”,FileFormatType.EXCEL2007); and it will work fine.

If you don’t specify a FileFormatType during save process, Aspose.Cells will try to save the file in Excel 2003 xls file format, which will cause problem in this case.

Please do let us know if you face any problem.

Thank You & Best Regards,

5

Hi

Ya, it works fine with this change. Thanks for your response.

Regards

Rachel