Read range takes so much time

Help Activities
, , ,
1

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

2

share the weird bugs

3

image
image1391×631 56 KB

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…

4

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.
    The image shows a configuration panel for finding the last data row in an Excel sheet named "Followup," with settings to consider only visible rows and columns with headers, and to save the row numbers for the first and last populated rows. (Captioned by AI)
    The image shows a configuration panel for finding the last data row in an Excel sheet named "Followup," with settings to consider only visible rows and columns with headers, and to save the row numbers for the first and last populated rows. (Captioned by AI)605×434 12.4 KB
  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””
    image
    image1217×448 24.4 KB

    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
5

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