Hi Team, I am working on the excel automation. In my project there are 10 xlsx files which contains single sheet each. Sheet names are unique for each excel. My target is to have a single excel file which is a merge of all the input excel file sheets. Input: xyzFolderPath\ExcelFileA.xlsx (only…

Below code will work as expected. Give a try Keep all the files from which you need to copy sheets in a single folder Then follow below code. In the properties of copy sheet- provide the destination file path and keep sheet name same as the source sheet name as those are unique [image] [image] …

Merge multiple excel file sheets into single excel file with multiple sheets

Help Activities

jai_kumar2 (jai kumar) November 29, 2024, 6:43am 9

Hi @hacky, you want to merge all sheets into one Excel file while keeping the same sheet names, but you’re not recommending including all the data from each sheet in the new file, correct?

Topic		Replies	Views
Merge multiple Excel files into a separate work sheets in single excel file Studio uiautomation	3	32	April 10, 2025
Merging 9 excels into 9 sheets in one excel Activities excel , question	1	632	September 6, 2021
How to merge different excel files into single excel file Automation Ops question , automation_ops	32	547	November 21, 2023
How to append all excel files from a file path to a single excel file Something Else feedback	12	1599	August 1, 2022
Merge Multiple Excels to Single Excel using UiPath \| Input sheets to separate sheets in output Excel Video Tutorials excel , activities , faq	0	695	September 20, 2022

Merge multiple excel file sheets into single excel file with multiple sheets

Related topics