How to copy mutiple sheets to single sheet with the range

how to copy particular sheets in an excel with a particular range and paste it in another excel.how to get range

Hi @anjani_priya ,
All sheet have similar data?
if they are same, we need for each sheet, read range each sheet then append range in target sheet, or get last index of target sheet to write
to detail, can you share your input and expect output?
regards,

Hi

You can try with copy paste range activity
with this u can mention the place to copy paste in another excel and also the range to be copied

This is a studioX activity but still be visible in studio as well
This doc has got an example as well

https://docs.uipath.com/activities/other/latest/productivity/copy-paste-range-x

If u want to copy paste within same excel then there is an activity in studio itself

https://docs.uipath.com/activities/other/latest/productivity/excel-copy-paste-range

Hope this helps

Cheers @anjani_priya

@anjani_priya

As you need to combine the data…it would be good to use read range activity with required range and then use append range activity to append the dtaa together or merge datatable activity

Cheers