Approach for automating excel with very large amount of data

[pearlb (Pdb)]

Hi All,

I have a process where in a VLOOKUP between 2 different files(Both files are very huge: 50+ Columns and 200,000+ rows) on 15+ columns is to be done. The current approach to automate this that I have used is UI based automation. Usage of DataTables is not an option since the column names are not unique.

Current Approach:

1. Select 5000 rows in loop and apply VLOOKUP formula to them. Batching is required as applying the formula to entire column takes around 15 mins and very high CPU utilization.

My queries are as follows:

1. The machine configuration for both DEV and UAT is exactly SAME, still When the process is executing in UAT, the user faces delay issues and not in DEV. I have handled the delay issues by using element exists wherever possible. Any reason why?

2. Is there a better approach to this process other than UI automation?

[andrzej.kniola (Andrzej Knioła)]

You could try to treat it as a DB:

Searching in excel table

Hello guys, Can you please help me with excel? Lets say I have a table in excel with n columns and i rows. I need to check if the values in one specific column are equals to mine saved in my data table in UiPath. Can you please somehow help me with the whole process? Firstly I find the column using send hotkeys to find a header. Then I dont know what should follow. Should I loop through every cell or should I just take the value from my data table and through send hotkey (ctrl+f) find if the c…

[Gauri_Walzade]

@pearlb
How did you solve this issue?
Kindly share with me the approach as I am building a similar process.