Merge two excel files

I was wondering if it is possible to merge two Excel files into one using Advanced ETL Processor.

Hi Carl.

There are multiple ways to merge two Excel files
For example, you may want to add data to the existing Excel sheet.
Or you may want to join the data by bringing the customer's name based on the customer id.
Both methods are supported by our software

It all depends on your requirements,
Please provide more specific examples and we will do our best to assist you

I want to insert a sheet from one Excel file into another and I want to keep the original formatting
I also want to make sure that the new sheet is the first one and it is an active sheet.

Basically, we validate the data for our customers and if there's something wrong we want to add a guidance sheet to the the file and email it back to the user

Good Morning Carl

Thank you for a detailed explanation. Using our software you can copy data from one Excel sheet to another, however, all formatting will be lost. Making sheet active and inserting sheets at specific position is not supported at the moment.

I have spoken with the developers and I was told that your requirements are very easy to implement.

We are planning another release next week and we will add your suggestions to it
\\\\\\\\\\i will let you know once it is ready

Hi Carl

Your request was implemented in the latest release

Changes are:

22/05/2022 6.3.11.20

+ Improved: Excel operation action
+ Added: Added ability to merge two Excel files without losing formatting
+ Added: Added ability to set Excel file active sheet

I hope a lot of our customers may find it useful

Fantastic, thank you for following this up so promptly.

We will check this out and let you know.