Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Style lost when combining workbooks with aspose

When combining many Excel files with aspose, I get a single workbook (Excel file with many sheets). But the problem is that I don't get the HTML style(color, font, size background color...) which was in each sheet before the merge.

Here is my java code:

 import com.aspose.cells.*;

  public static void main(String args[]){

        Workbook workbook = new Workbook();
        Workbook introductionWorkbook = new Workbook("reports/introduction.xlsx");
        Workbook conclusionWorkbook = new Workbook("reports/conclusion.xlsx");
        
        workbook.combine(introductionWorkbook);
        workbook.combine(conclusionWorkbook); 

        //save the merged file
        workbook.save("/reports/merged_file.xlsx");
}

I don't know if there is an option to make aspose take into consideration the style when combining workbooks?

For example, I have a text like this is my Excel sheet before it get merged

enter image description here

After it get merged, it become like this

enter image description here

like image 455
amani92 Avatar asked Feb 24 '17 11:02

amani92


1 Answers

Downloaded the latest version(aspose-cells-17.02.0-java.zip) from here and it looks working fine.

enter image description here

like image 145
skadya Avatar answered Sep 22 '22 18:09

skadya