Read range takes so much time

i have to read an excel with 7-10k rows and when i use read range (workbook) is giving me some weird bugs so i use read range with scope (excel) but it takes sooooo long to read actually never ends… what can i do? i have to work with the inner values and sheets…

if i read smaller excels works perfectly

share the weird bugs

Here shows in debug mode the real name but the error says another name which is not even in excel. Dont know from where is taking it. if i run a smaller one with this activity this error never happend

i saw surfing in this forum that this is a common bug still unsolved…

I’m too facing where i need to do lot of reconciliation and filter over 13-15k rows. This is my alter approach.

  1. To find number of rows if you know column name below, else Excel(“sheetname”).column(0).name.
  2. TO filter, directly apply macro formula to one dummy excel column by
    Write Cell and AUto Fill Range activity. then do filter activity “criteria if no matching column value “#N/A””

    Use Copy/Paste range activity will copy only filtered visible rows
  3. If its one time activity use “Read range workbook” after closing that excel

Try following

  1. Instead of taking sheet name from Config file - Hard Code the sheet name for testing
  2. Try providing range equallant to the actual number of rows., Example - “A1: Z70000”. See whether it is working fine or not
  3. If it is working fine - Try deleting all the rows below 7000 and columns where data is not there manually and give a try without providing the range.

share the results. We will discuss after that

@amy93amanda