Hi, Experts, How to do CV exctract table Scrolling down dynamic?

Help Studio
, ,
1

Hi, guys !
I want to make the CV Extract Table Scrolling down dynamic.

for Ex- I have 200 of records in excel file, while extracting the data from excel once the bot reached 200 row then bot should stop the scrolling down.

Computer Vision

Thanks

2

@Sanket_Shinde1

Main tain a counter and after each extract add the extracted count to the counter and once it is 200 end the loop of scrolling

initialize counter = 0
While counter <200
Extract
scroll
increment the counter = counter + dt.RowCount

The above is the structure how it should loop

cheers

1 Like
3

but thing is that sometime in excel has any number of rows, so how can we do that?
CV
May sometime excel has 100 records / 200 records likewise
so will stop scrolling after the last row.

Computer vision

Thanks

4

@Sanket_Shinde1

Check if the first row in the returned datatable is empty …if empty then stop…this can be one more condition to above

dt.Rows(0).ItemArray.All(function(x) IsNothing(x) OrElse String.IsNullorEmpty(x.Trim)) - this will give true if all values of a row are empty else false

cheers

5

I have tried but not able to do,
my workflow is like this, CV

  1. cv screen scop : indicated the Excel file (which has number of records assume 400)

  2. cv extract table : Getting excel data and storing in dt
    but when extraction is complete means bot reached to last of record 400th
    still scrolling down till 5800 rows then stop extracting ,

    BOT SHOULD STOP AFTER THE 400 th row AND SHOULD GO TO NEXT ACTIVITY
    THIS SHOULD BE DYNAMIC now I have 400 records next time 100 / 200 / 800 likewise

  3. write range activity.

6

@Sanket_Shinde1

I dont see a loop at all in thsi

please do it properly

cheers