How to get text on the bases of text color

Help Studio
, ,
1

Hi,

can you tell me How to get text based on the text color in UiPath.

Sample Data:

image

in the above sheet text color bases get data from another sheet also.

Thanks
Shyam

2

Hi,

This workflow will if the color is constant
Main.xaml (14.7 KB)

3

Hi @RK_0,

Could you share your approach? Attaching a .xaml file is helpful, but it means that one has to download it and comprehend the approach you used.

  • A screenshot of your approach would avoid duplicate answers from other forum members
  • In the future, when others have the same problem, they can resolve their issue without having to download the .xaml
  • Many forum members like reading the answers for quick understading and like to compare solutions before using one of them

As the adage goes
“If you give a man a fish, you feed him for a day. If you teach a man to fish, you feed him for a lifetime.”

4

I have used this in one of my previous projects, so I shared it with him.
The workflow follows the following steps.

  • This has to performed in the Excel application scope and read the excel
  • in for each row - drag get cell colour and pass Columnname+ counter: A2
    This work only if the column name and colors used are constant throughout the process
    using switch and argument as system.drawing.color
    color name as case

colour1

colour2
colour2718×475 13.9 KB

1 Like
5

Hi @RK_0

Your are share get cell color activity… this isn’t right one.

see the input data… See the Sl.No.4 the text color is red i am going text color is Red in all worksheet red color text to write in one place. this is my requirement.

Thanks
Shyam