Style lost when combining workbooks with aspose

Question

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

After it get merged, it become like this

Style lost when combining workbooks with aspose

Answers (1)

Related Questions