How to copy excel to another exist excel with formula

Help Activities
,
1

Hi i am trying copy a range of data to another existing excel

excel1
excel1724×746 40.7 KB

Excel2
Excel21160×796 34 KB

I want to copy highlighted information in excel 1 to excel 2
is it possible copy it directly to excel 2 without create new sheet ?
Thank you!

2

Hi @Edd_0820

Yes UiPath will create a new sheet if not present already of we use write range activity.

Please try this steps,

  1. Read the data in Excel1 using read range activity (give range as “B1:E20” and store it in the datatable variable name dt.

  2. Use write range activity and pass datatable as dt, check AddHeaders property in properties panel.

Thanks

3

Hi

Hope these below steps would help resolve this

Welcome back to UiPath forum

—use a EXCEL APPLICATION SCOPE and pass the filepath of excel1 and inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt

—then use a WRITE RANGE ACTIVITY where pass the above dt as input and enable ADD HEADERS property in property panel
And for sheet name

Ofcourse it is possible provided if you know the sheet name in excel2
So that you can mention the same sheetname in the WRITE RANGE activity or else by default “Sheet1” will be there in that activity and the data also will be stored in that sheet1 in excel2

Cheers @Edd_0820

4

Hi @Edd_0820

Is your issue resolved?

Thanks