CV EXTRACT TABLE FOR SCROLLABLE TABLE

[Arvind1 (Arvind)]

HI I WANT TO EXTRACT A HORIZONTAL AND VERTICAL SCROLLABLE TABLE ON VIRTUAL ENVIRONMENT, SO HOW I EXTRACT , THE TABLE IS SCROLLABLE AND CONTAIN 500 TO 800 HUNDRED RECORDS, I AM USING CV SCOPE FOR THIS , PLEASE SUGGEST A GOOD METHOD TO EXTRACT SCROLLABLE TABLE

[Nikhil_Zambare1 (Nikhil Zambare)]

Dear @Arvind1,

Please use extract CV table activity to extract table.
Here you can make use of scroll properties to scroll vertically/horizontally.

→ In the Scroll options, Check the Scrollable Table option to True.
→ In the Scroll direction, select the Down option from dropdown.

PFB below snap for reference:

Kindly mark as solution, if it solves your issue.

Br,
NikZ

[Arvind1 (Arvind)]

Hi Nikhil,
The particular properties works well for vertical table for some data, not for the horizontal table, but my table is vertical as well as horizontal, or the activity is just extract some data , but i want to extract 500 data from the table, any suggestion

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Arvind1

Have you tried like below?

When you indicate scope for CV, pressing F2 and then doing both the scrolls. After that extracting table data from the screen?

CV records the scrolls/application state during capture time.

Please try and see if this helps.

[Arvind1 (Arvind)]

Hi @ Sonia
Thanks for replying , i understand your concerns , but when the table is very long then it struggle to extract table, it will help when the data table have 50 -80 records,

[sonaliaggarwal47 (Sonali Aggarwal)]

@Arvind1

Are all 500 or more records are on 1 page itself with scroll?

No multiple pages?

[Arvind1 (Arvind)]

yes, and need scrolling both side means down and right

[Arvind1 (Arvind)]

Hi @Sonali,
can we make code with do while activity and with take care of scrolling and last rows which we extract before and append the data to main table at every scrolling

[sonaliaggarwal47 (Sonali Aggarwal)]

@Arvind1

Please refer below, if helps

Scrolling in UiPath Computer Vision: How Does It Work?

You can also give a try to non CV based table extraction wizard activity.

Refer more for details

Table Extraction With Infinite Scrolling In UiPath - Full Tutorial

Also refer below post, it has some tips. If none of the above solution works. May be put your extract table activity in a loop, after each extraction , scroll using scroll activity specifically and then next extraction happens.

Unable extract the all the rows from web data table

I am trying to extract a table from a site using data scraping. But UiPath only fetches first few rows. I tried using scrolling down and then data scraping. But then it only fetches last few rows. I have tried with classic and modern activities like data scrapping, table extraction, generate data table, mouse scroll, do while condition, get full text and send hot keys but no use. My table is in single page but need to scroll down to seen more rows and there is no 'next page ’ option in my web …

[Arvind1 (Arvind)]

Hi @Sonali,
Thanks for recommendation,
i will try

[prashant1603765 (Prashant Kumar)]

Hi @Arvind1

Try to use CV Scope with Anchor Base to identify the table header. Scroll vertically and horizontally in loops, extracting visible data chunk by chunk using OCR or Find Children activities. Append each extracted part to a DataTable. Use Image Exists or Element Exists to detect when you reach the end of the scroll.

If helpful, mark as solution. Happy automation with UiPath

[Anil_G (Anil Gorthi)]

@Arvind1

1. Try to install runtime if that is done then you can use normal activiites
2. If 1 is not possible then implementing loop and doing some data massaging is what we need to do
   First extract the data with vertical scrollong ..then scroll horizontal from first and extract again..then the tables can be written sixe by side on excel

Cheers

[Aleem_Khan (Aleem Anwer)]

You can enable scrollable table = true in table extraction property setting