We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cell lost the background color during excel sheet open and save

Hi,

I am using aspose 2.2 license version.

in my project i am using following code.

Workbook workbook = new Workbook();
try {
workbook.open(excelFilePath);
workbook.save(excelFilePath);
} catch (IOException e) {
}

after saving excel file my cell color getting lost,

here i attached before and after saving excel files, pls check the third sheet name as "1". after saving my cell red color getting lost.

pleas help me.

Hi,


As you are using some older version of the product for which we are not sure. I have tested by opening and resaving your template file with our latest version e.g v7.3.5.x (you may download our latest official release v7.3.5 2 here: http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry434437.aspx), it works fine. The color is retained in the “1” sheet.

Sample code (with latest version):

Workbook workbook1 = new Workbook(“before_open_and_save.xls”);
workbook1.save(“after_open_and_save.xls”);

Thank you.