How to combine or merge excel file multiple sheets into single

Aspose.Cells App Product Family
1

How to combine multiple sheets into single
For this, I don’t need to upload 2 files. But when I use Merger functionality it is asking me to upload 2 files.
I need this functionality for a single excel file that has multiple sheets.
Could you please help?
Also, I can see that it’s ignoring the conditional format, may I know why?

2

@surawens

Aspose.Cells web app doesn’t provide such a feature. You can use our back-end Aspose.Cells API as a workaround.
Please go through the following documentation articles:

However, we are further looking into this scenario (if such a feature could be added). Your investigation ticket ID is CELLSAPP-1085.

Could you please share the sample/problematic files? We’ll then look into this scenario at our end.

3

@surawens
We have improved the features you mentioned. Please try again. We welcome any feedback from you. Thanks.

4

Thanks a lot :slightly_smiling_face: Nick & team.
I am very happy, you should be having a wonderful team :slightly_smiling_face:

I am attaching here a sample excel which has multiple sheets. Please combine once and see the result.
I have noticed a few minor issues, I thought reporting this will help improve our product.
Daily Status Report Sample.zip (48.3 KB)
Please let me know if you have any questions.

5

@surawens
Thank you for giving us feedback and providing sample file. We will carefully compare the differences between the merged result and the original file, and provide a fix as soon as possible.

6

Thanks Nick. Appreciate your help.

7

@surawens

You’re welcome.

8

@surawens
We have fixed most of the bugs, but because your conditional format contains references to other worksheets, after merging, the conditional format cannot be calculated.

9

Thank you very much Nick & Team :slight_smile: