Faster UiPath Automation

Help Activities
, ,
1

Hi

I have created a backfilling automation which takes the values from one excel to another using Lookup data table & Excel Application activities.

But I was wondering How Can I make this automation bit faster as it’s taking more than 10 mins for 250 rows.

Regards
Naman

2

Hi @Naman_Arora ,
10 mins for 250 rows is too slow
You can share your in/out
I will try
Regards,
LNV

3

@Nguyen_Van_Luong1
Hi

You want UiPath automation or Input & Output Sheet ?

Regards
Naman

4

Hi, I want input file and expected results

5

Hi @Naman_Arora,

if you are using the modern excel activities, then use the below settings/properties value for the Read range activity
Visible rows only – False
Read formatting - RawValue
This will make the operation of reading the excel faster.

6

@Sharath_HK
Hi

I’m using classic activities only. Read Range Workbook & Write cell Workbook.

Regards
Naman

7

@Nguyen_Van_Luong1
Hi

The files contains some data which cannot be shared. I can only share the bot let me know if you can help me with the same.

Regards
Naman

8

Hi,
I understand that some files that need to be secured cannot be public
ok send me the same
I will try then send to you my best solution

9

@Nguyen_Van_Luong1
Here

Let me know what can I do to make it faster.

Regards
Naman
Main.xaml (18.9 KB)

10

Oh, I want the same data to test with my solution

11

@Nguyen_Van_Luong1

Okay, Can you share your solution I’ll test it with my Input.

Thanks
Naman

12

@Nguyen_Van_Luong1
I’ll give you an update how much time it is taking.

13

Hi,
I checked your xaml file
here you leave the data file reading in the loop
so it will be very slow
with each loop the file test reads the data file once
it will be exponential
for example test file has 1000 lines, reading data file also happens 1000 times
and so the comparison will also multiply
this can totally be improved

14

ok, can you share your test and data file I will test it
I will send you my solution later

15

Okay Got it

So What Can I do in order to avoid this & have a faster working automation.

Regards
Naman

16

@Nguyen_Van_Luong1

Yes Please. That will be really great,

Because i’m still in learning phase. So I can use your solution as example.

Thank you so much :slight_smile:

17

Hi
because no data test.xlsx and data.xlsx
I will simulate the same steps

  1. read test.xlsx to get data test
    image
    image1274×360 17.6 KB

    2.read data.xlsx to get data
    image
    image798×782 22.2 KB

    3.Use for loop compare then assign value
    4.Write cell in scope to write back data
    ( this step you can write after compare data to faster)

→ this solution will faster than your solution

You can try that
but, the best is send me a message
I want to test with your data
Regards,
LNV

18

@Nguyen_Van_Luong1
Hi

Can you give an example with Lookup data table activity ?

I wanted to make this faster.

Regards
Naman

19

hi,
I need data to check
You need send me same data

I don’t have data,
I don’t imagine your data