Writing the Data to an Existing Excel template

DataPirate26

I have 3 Excel Files and each File has 3 tabs in it which has different structure so the schema is not same. But all the 3 Files has similar structure. The requirement is that I have to take the Data from all the Input Files and Write it into an existing Excel template which also has the similar structure as of the input Files. 

Test File.xlsx

Output File.xlsx

test File 2.xlsx

danilang

Hi @DataPirate26 

Check out the solution to this post by @AbhilashR which shows how to create a copy of the template file and then writing to the copy.

Dan