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

Yoichi (Yoichi) November 29, 2024, 5:52am 3

Hi,

How about using Classic CopySheet activity as the following?

Sample
Sample20241129-2.zip (23.0 KB)

Regards,

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