In this article, you will learn how to create a workflow using one method to merge 2 Excel spreadsheets with the same columns into 1 file. Find the downloadable files we used at the end of this document.
Here’s how to do it in a few steps according to the activities you choose. We offer you two different combinations in the following instructions.
Merging spreadsheets content with Read Excel File and For Each Row Activities
Read the first Excel table using Read Excel File.
Read the second Excel file also using Read Excel File activity and save the results in different variables.
Create a third Excel file that will be the result of the merge, inside this Excel file add the content of the first Excel file that was read.
Now use the For each row activity but first, it's necessary to create an Index, and inside of the “For each row“ add +1 in the index.
Also, inside the For each row activity insert the Append row to Excel file activity with the following value:
6. Finally, the complete workflow should look like this screenshot.
Merging spreadsheets content with Read Excel Range and Write Excel Range Activities
First, read the table from the second file using Read Excel Range.
3. The resulting table will look like the following screenshot.