How to Move Excel Sheet to New Excel File?

[Perawat]

Hi, I have three excel files. I will combine the sheets of all 3 files as the new excel file names. I have the following information.
1150101.xlsx (9.1 KB) 5140104.xlsx (9.3 KB) MB51.xlsx (9.4 KB)

This image is a new excel file that includes each sheet.

Thanks.
Perawat

[Arpit_Kesharwani]

@Perawat loop over each sheet of each file and Use cooy sheet activity

[1996 (Neelima G)]

Hi @Perawat,

Can you try below link hope it will help to understand how to move excel sheet to another excel.

Copy/Move Excel Sheets to Other WorkBook

Hi All, I want to copy/move excel sheets to other workbook. I have checked the link for the excelcopysheet activity, but it is not available in my studio (version 2018.2) we need the data to be copied with source formatting and we need to copy more than 10 sheets from 4-5 workbook to one workbook. checked this link as well, but no hope

If solution is working for you please mark it as solution.

Thanks,
Neelima.

[balupad14 (Balamurugan)]

Hi @Perawat,

Here is an activity called “Copy to file” from balareva.excel.Activities.

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Here is use case video. Inside I have used this activity.

UiPath Case Study | Dynamic excel file creation (BalaReva)

Regards
Balamurugan.S