Need to copy the data from one excel to another excel sheet

[sushmithaelluru (sushmitha)]

In my requirement, I need to copy the data from one excel sheet(INV report) to another excel sheet(BPI report). But in the sheet(INV report) where I need to paste has some data. So I need to delete that data there first and then copy the data from BPI to INV.

Can anyone tell, which activities need to be used !!

Thanks.

[Sreelatha278 (Sree Latha Reddy)]

Read BPI report using read range activity and place in output datatable dt.
then write dt to INV report using write range activity, it will overwrite all data in INV.

[sushmithaelluru (sushmitha)]

Thanks @Sreelatha278, the INV report is Macro enabled worksheet!! write range activity is not able to take that sheet.

[Sreelatha278 (Sree Latha Reddy)]

@sushmithaelluru

Please use excel activities instead of workbook activities as .xlsm only works with Excel Application Scope

[balupad14 (Balamurugan)]

Hi ,

This will help you to solve you problem.

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

[jboli48867 (John A Bolinger)]

Hey Balamurugan,
Do you have something similar to Copy to File, but instead of creating a new excel file I want to add that copied sheet to an already existing excel file.

For Example:
I want to copy sheet 1 from Excel File A and place that copy of sheet 1 into the already existing file Excel File B.

Thoughts? I tried using copy to file this way and left auto file create as false but it does not seem to work.

Thanks,
John

[balupad14 (Balamurugan)]

Yes @jboli48867. you have it.

you can use the activity Copy to WorkBook It will copy inside the work book. check it below.

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…

you can get the package from here.

https://go.uipath.com/component/balareva-xl-activities

Regards
Balamurugan.S