Any option to read colour out of tabular data from a web page

Help Studio
, ,
1

I am working on a Web page where data is in tabular format, but I need to work on rows that do not have any color, I need to skip rows with color.

Any option or activity which can read color, FYI I tried get attribute activity and also checked selectors.

Any suggestions???

image
image1829×328 24.6 KB

Thank you in advance

2

@Ulhas_Guttikar
Yes, it is possible to read the color of cells in a table on a web page using UiPath. Here are the steps you can follow to do this:

  1. Use the “Get Table” activity to extract the table data from the web page. This activity will return a DataTable object containing the table data.
  2. Use a “For Each Row” loop to iterate over the rows in the DataTable. Inside the loop, you can use the “Get Cell Color” activity to retrieve the color of a specific cell in the table.
  3. Use a “Write Line” activity to output the cell color to the log or to a variable. You can also use other activities, such as “Set Text” or “Type Into”, to enter the cell color into a text field or other element on the web page.

Here is an example of how this might look in a UiPath workflow:
Get Table activity (to extract the table data)
For Each Row loop (to iterate over the rows in the DataTable)
Get Cell Color activity (to retrieve the color of a specific cell)
Write Line activity (to output the cell color to the log)
End For Each Row loop

Keep in mind that you will need to specify the column and row indices for the cell that you want to retrieve the color for. You may also need to use additional activities, such as “Find Element” or “Click”, to navigate to the web page and interact with the table.

3

Hi @deepak.rai6

Thank you so much for your time.

I got little confuse, Get table activity or Extract Data table?

Get cell colour activity need workbook path as input, what should I write there??
image

Thank you once again.

4

@Ulhas_Guttikar

Use get attribute and get the color hex code…which can then be used to get rgb as well

Cheers

5

Hi @Ulhas_Guttikar ,

i am sure UiPath have solution to read the color. please try the suggestion from our forum members on get color code or get RGB value to identify the color of the UI elements.

wanted to share my suggestion on the problem you posted.

Could you check in what scenario we are getting the color of the table rows. in my opinion i dont think the application will not put color randomly for the records there should be some reason it is applying red color or pink color or no color due to some conditions. there is column i could see in the screenshot is like un restricted for red and if it is specific project there is no color and some other scenario for pink color.

Check with your business on what scenario we are getting colors so that it would be helpful for you to build robust automation. thanks.

Regards,
Kirankumar.

6

Hi @kirankumar.mahanthi1

Thanks for the suggestion, the red color has already been taken care, the pink color is Bug in the system, which can occur randomly. we have checked all possible scenarios but color is the only option.

7

Hi @Ulhas_Guttikar ,

ok got it then no other go we have to go for color.

sharing some suggestions for identifying color for the rows in website.

  1. i know you already tried using get attribute activity. did you try for the style attribute it will give you the entire css style info from the website definitely there is information related for color.

  2. Try the below custom package from the UiPath market place(if you organization allows for third party packages) it would provide the CSS property info from the website so that you can identify the color. give it a try. thanks.