Description
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.
Instructions
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:
excel_content2["Sheet1"][i]
.
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.
-
Then, select the Write Excel Range activity to insert the value in the created file.
3. The resulting table will look like the following screenshot.