Free Support Forum - aspose.com

ASPOSE Cells for java 7.0.1 version cell format isssue-copy worksheet

Hi Aspose team,

Copy of a worksheet from Source file to destination file is not retaining cell formats ---

In source file there is no border for cells but in destination file - cells are getting border .

Attached is the soucefile that I have used. Any suggestion on how to keep all the formats from source file in destinatin file while copy.

com.aspose.cells.Workbook destWorkbook = new com.aspose.cells.Workbook();//
com.aspose.cells.Workbook srcWorkbook = new com.aspose.cells.Workbook(srcFilePath);
destWorkbook.getWorksheets().get(0).copy(srcWorkbook.getWorksheets().get(0));
destWorkbook.save(destFile);

Thanks in advace for help.

Hi,

Please download and try the latest version:
Aspose.Cells for Java v7.0.2


I found, it is working fine.

Please see the code below and the output xlsx file generated with the latest version.

Java


String filePath = “F:\Shak-Data-RW\Downloads\Aspose7.0.1_test_10_19_11_02_09_38_811_PM.xlsx”;


com.aspose.cells.Workbook destWorkbook = new com.aspose.cells.Workbook();//

com.aspose.cells.Workbook srcWorkbook = new com.aspose.cells.Workbook(filePath);

destWorkbook.getWorksheets().get(0).copy(srcWorkbook.getWorksheets().get(0));

destWorkbook.save(filePath + “.out.xlsx”);