Appending sheets from one excel file to another excel file

[mohini1329]

I have two excel files(File1 and File2), each with 4 sheets into it. I want to append all the sheets from File2 to File1.

Actual Scenario:
A.xlsx
A1.xlsx
B.xlsx
B1.xlsx

All the above files are kept in the same folder and I want to combine files on the basis of file name.
So I want to combine A and A1 to A and B and B1 to B and store the consolidated Files to a new location.

i.e. sheets from file A1 would be appended with the sheets of A

[marvin.kickuth]

Hi @mohini1329,

I’m not quite sure what you want to do, as you mention two files but then list four xlsx files.
However, you may be able to use this workflow to read all sheets within a file and then append them to another:

Read all sheets from an XLS file in a loop – scottF

Kind regards
Marvin

[mlauber71]

@mohini1329 you could check these examples and adapt then. The necessary elements should all be there. You might also want to provide an example of how your scenario would look like.

I want solution of this problem

@mythxAHIR you might want to take a look at this example and see if you can adapt that. At the core the sheet name will be inserted as a column. You should have all the elements that you would need to combine the elements accoring to your needs: [image]

Read the sheet names from an existing excel file and add the sheet name as a...

How to add Multiple Excel File data into one Excel File Sheet wise?

@mythxAHIR this could be done like this: [image] You use the names of the imported Excel files to have the sheet names to export into a single target excel file. [image]

Collect data from 4 differet Excel files and put it into sheets of a single...