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.
Hi @Naman_Arora ,
10 mins for 250 rows is too slow
You can share your in/out
I will try
You want UiPath automation or Input & Output Sheet ?
Hi, I want input file and expected results
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.
I’m using classic activities only. Read Range Workbook & Write cell Workbook.
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.
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
Let me know what can I do to make it faster.
Main.xaml (18.9 KB)
Oh, I want the same data to test with my solution
Okay, Can you share your solution I’ll test it with my Input.
I’ll give you an update how much time it is taking.
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
ok, can you share your test and data file I will test it
I will send you my solution later
Okay Got it
So What Can I do in order to avoid this & have a faster working automation.
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
because no data test.xlsx and data.xlsx
I will simulate the same steps
- read test.xlsx to get data test
2.read data.xlsx to get data
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
Can you give an example with Lookup data table activity ?
I wanted to make this faster.
I need data to check
You need send me same data
I don’t have data,
I don’t imagine your data