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

Help Studio
, ,
1

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)

2

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

Output i got

image
image1118Ă—343 10.3 KB

(ignore the color headers )

regards,
Nived N

3

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 ?

4

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

5

@Anand_Designer
Here is the answer for the python code

image

See that it takes only 139ms to execute the whole

use UiPath.Python.Activities to execute it

1 Like