Copy data from product excel file to Master file in Data sheet particular columns

Hi,
i have input excel file is product.xlsx copy whole data then paste into master file in DATA sheet particular columns like A to E columns
can any one help about this ?product.xlsx (8.3 KB)
mastersheet.xlsx (10.5 KB)

Hi @Anand_Designer
Try this simple appraoch
Main.xaml (12.7 KB)

Output i got

(ignore the color headers )

regards,
Nived N

Hi @NIVED_NAMBIAR
its working fine . but if it large volume of data like more than 5000 Rows to 6000 Rows its showing long time Robot running mode. how to avoid this ?
is there any alternate method ?

hi @Anand_Designer

I think for larger number of rows it would take time. else try this appraoch as well

Also for larger datasets , python code is also effiencet ways as well. You can invoke the python code in uipath to acheive this

I will share the code in next reply

@Anand_Designer
Here is the answer for the python code

See that it takes only 139ms to execute the whole

use UiPath.Python.Activities to execute it

1 Like