How to filter the value by colour in a column in UiPath.
Some of the values are in colour, how to filter them
Hey @anjani_priya
There’s no native activity in UiPath to filter values based on cell color in Excel, but you can try use Get Cell Color activity to get the cell color and store relevant data in a new DataTable based on the results.
You will have to use VBA Macro for this. No native or prebuild activity available in the Studio.
Here you can achieve this process by looping all records and in loop you have to use get cell color activity, based on your condition on color create new data table.
Asssum you have data table,
use for each row
inside loop use get cell color
get output
make one condition if color is red or something
in then branch add that row to one new data table
if not in else branch use another data table which recommends the non colored data.
By following this process you can filter your data.
And you can go throw below thread as well
happy automation!!
you cannot directly filter values by color in a column. To do this, use the “Get Text” or “Get Full Text” activity to extract the cell values and their color properties. Then, use “Find Element” to get the color of a specific cell, check the color using a condition (like RGB or Hex values), and filter the values based on the extracted color, storing them in a list.
Checkout below Link for more:
If found helpful, mark as a solution. Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.