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
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