Copy/Move Excel Sheets to Other WorkBook

[sarathi125 (Parthasarathi)]

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)

Activities - Copy Sheet

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

How to combine multiple excel files into one workbook with multiple sheets

Hi @canlilar, Use the below logic. Create a string variable named as “Filenames” Assign Filenames = Directory.Getfiles(“Folderpath”) For each item in Filenames, item type as String Excel application scope, In workbook path give item. Use Read range with output as Datatable1 Excel application scope, In workbook path give a new output file name. Use Write range with input as Datatable1, sheetname as item.

[pavanh003 (Pavan Harisha)]

Hi,
did you try with balareva ecel activites from manage packages.

Let us know if you can solve using balareva packages from manage packages.
Regards,
Pavan H

[varunk (Varun Kumar)]

HI @sarathi125,

After reading excel file
You can use that data table name in for each,Inside for each you can keep that move file activity to move file from one folder to other

[balupad14 (Balamurugan)]

Hi @sarathi125

Yes @pavanh003 said right. you can use this package to achieve this.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Here you can get the detail . the examples are used the UiPath Gallery.

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…

Regards
Balamurugan.S

[sarathi125 (Parthasarathi)]

Hi @balupad14,

Thank you for the details, but not able to open the copytofile.zip xaml in studio 2018.2.3 version.
Do we need to include any dll, I am getting this below error.
Could not find type ‘BalaReva.Excel.Sheets.CopyToFile’ in assembly ‘BalaReva.Excel’. Row: 57, Column: 6

[balupad14 (Balamurugan)]

It is using the gallery. You can download it from UIPATH go at local and configure it.
Regards
Balamurugan.S

[sarathi125 (Parthasarathi)]

Thanks Bala, with the latest UiPath Excel Activities package version 2.5.2 that can be done with the CopySheet activity.

Thank you all for your support.