Extract table data2002

Help Automation Suite
1

I want to extract only a particular cell value as example in this imagine i just want to take first reference id and put it in workbook .. hoow do i do that in UiPath

2

Hi @poojaskyrathore,

Can you share the image.

If you are using excel then you can use Read Cell Value activity to get the value and Write Cell value activity to write the value.

Thanks

3

17835952770402193972673100411701
178359527704021939726731004117011920×2560 1.25 MB

4

Hi @poojaskyrathore

Use Extract Table Data to get the table into a DataTable, then take the first row and required column value.
Example after extraction: dtTable.Rows(0)("Reference ID").ToString → this gives the first Reference ID.
Then write it to Excel using Write Cell / Write Cell Workbook with that value.
If you only need one cell and not the full table, use Get Text on that specific cell instead of Extract Table Data.

Happy Automation

5

Not able to extract data table cause it says elivated priveledges required

6

@poojaskyrathore

I see its banking related application so there could be extra security which is restricting UiPath from scraping it.

Check the DOM of the application through Developer tool on the browser by pressing F12 button.

7

Could you provide detailed solution plzz

8

Difficult to help only on the basis of screenshots and back and forth conversations. Have you checked this?

9

Hi @poojaskyrathore,

Are you able to retrieve any values from this table using Get Text or Extract Table Data?

Thanks

10

No i am not able to retrive

11
  1. Use the For Each UI Element activity to iterate through the cells (or rows) containing the reference IDs.
  2. Inside the loop, use the appropriate Get Text (or Get Attribute, if applicable) activity to extract the value of the Reference ID from the current UI element.
  3. Store the extracted value in a String variable (for example, referenceId).
  4. Use the Write Cell (or Write Cell Workbook) activity to write the value to your Excel workbook.
  5. To write each extracted value to the next row automatically, either:
    -Use an integer counter variable (for example, rowIndex) and increment it after each iteration, or
    -Enable the activity’s auto-increment option if you’re using a workflow that supports it.
12

Hi @poojaskyrathore,

If this is a Citrix, Remote Desktop, or Java application where UiPath can’t access the table, use computer vision (if selectors don’t work). Try to use CV Get Text or CV Extract Table.

Cheers!