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
Downloaded the latest version(aspose-cells-17.02.0-java.zip) from here and it looks working fine.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With