Challenge! How to extract Hidden rows i datatable

HI Team,

When attempting to extract data from a table in a webpage using UiPath, I encountered a challenge where the bot was unable to extract or click on rows that were not visible without scrolling. I have tried using the “Extract Data Table” activity, but it only extracts visible data. Additionally, enabling the “Simulate Click” option in the click activity did not work as it only clicked on visible rows. Does anyone have suggestions on how to extract or click on hidden rows within the table? Any help would be greatly appreciated.

and Need to click one after other rows and it will navigate to other info page there I need to extract the data table and again navigate back click on next row.

@supermanPunch @ppr Can you guys help me in this?

best regards
copyrights

I believe,you can use mouse scroll activity until where the table is present so that the table will load first, then use extract data table to extract the data.

@copy_writes

Use Keyboard shortcuts activity use “End” or “Down”
image

Hi @copy_writes

Try using Mouse Scroll activity:

image

Regards

Thanks for the Quick replay.

I am not using modern UiPath I am using 2020.10.2 version.

and in this page short cut is not working as expected

Hi @copy_writes

Then try Send Hotekys:

image

Regards

Hi @copy_writes

While extracting the datatable, Try by selecting some other rows rather than selecting by 1st row 1st column.
Try selecting the 2nd row 2nd column or 3rd row 3rd column… likewise and check once.
At some Point it will extract the whole datatable.
UiPath is extracting the datatable for some websites differently,depends on the behaviour of the websites.

Hope it helps!!

Shortcut and hotkeys key is not working in this page

Yes I tried that it extract only one row that time

Hi @copy_writes

Then check whether all rows are getting selected from that page. If not, indicate the row which is not getting selected and check whether entire data is being selected by clicking Preview. At some point, indicating certain rows will extract the entire data table.

If possible can you please share the web page screenshot?

Regards

I check that all row are selected and it will validated also if the row is not hidden if the row is hidden its throw error and while extract data table it extract only the visible rows.

@copy_writes

Have you checked by selecting in the centre?

Hi @copy_writes

If possible can you share the webpage screenshot?

Regards

Yes I tried its not working it is extract only the 3 rows which is visible

Its quite difficult.

Please check the below I given example Image.

which ever blur that is data table

You can see only 3 row is present in that only those bot is extrcating

@copy_writes

Go to the Last row of your data in the webpage and extract the last row data and save the result and see you got all the data or not

I hope this will works

No Its not allowed to extract UiPath throw error.

If in case extract the all the value in data table using data scrape or any other method how we can click hidden rows.

@vrdabberu @rlgandu @pravallikapaluri @tazunnisa.badavide

@copy_writes

Use Get Full Text activity it extracts all hidden data it gives a string data by using string manipulations or regex expressions you have to format the data as table

Hi @copy_writes

Use Get Full Text activity the output will be string right, after that you can try using Generate Data Table to Text to convert it into datatable.

Regards