There is problem when I open Excel 2007 xlsm format sheet and save it. Some cells gets populated with wrong data and color formatting of some cells got lost or got changed. Please note that out sheet contains some macros.
I am just using the following code .
String inputFilePath = "C:\\excel.xlsm" String inputFilePath = "C:\\excel_copy.xlsm" workbook.open(inputFilePath, FileFormatType.EXCEL2007XLSM ); workbook.save(outputFilePath, FileFormatType.EXCEL2007XLSM);
It is particularly giving wrong results for the sheets that contains some macros.
Like for the following attached sheet "excel.xlsm" , when I just open and save it using above apose program then some formatting is lost in copied sheet and also MS Excel gives some warning message while opening the copied sheet.