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
