I'm trying to combine multiple workbooks, generated by an external application, to a new workbook.
The source workbooks including some table data and different charts. The charts are referencing to data, stored in a hidden worksheet with the same name ("_hidden2") in each of the source workbooks.
I use the method workbook#combine() to solve this but I'm struggling with the following problems:
1. The format of the charts changes (colors, format of labels, legend ...)
2. The hidden sheets are getting combined to new sheets "_hidden3", "_hidden4" and so on, but the references of the chart series doesn't change to the new destination names
Is there an easy way to solve this? I'm new to Aspose Cells, evaluating it to use it within a new application.
Thanks in advance,