UI Path very slow with huge Excel file

[badita (Mihai Badita)]

Take a look here. The idea would be to read chunks of data into memory (datatable), do the processing and save everything at once.

How to delete a row in excel using invoke method

Hello, I am trying to read a 89 MB excel file with 455302 rows. if I use the read range (a system activity) it UiPath frozen and stop working, but if I use excel application scope anad a read column read column activity works great, but the problem is that I would like to delete the file that contains “X” parameter in the many rows, I tried to use method delete, by using invoke method, but I can’t tell the method to delete a row from a IEnumerable object data type. I know the row number but I…