Appending sheets from one excel file to another excel file

[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...