How to get text color from excel

Help Studio
1

Hi Ui Path,

I have data as below in excel

Name Color
ABC
XYZ
123
456

where ABC text is in red, XYZ text is in Yellow,123 text is in Green and 456 text is in Blue color, i want to get text color names in Color column.

Any help or Guidance!

Thank you,
Mirza

2

Hi @Mirza_Hussain

Have a look on the docs

Regards
Gokul

3

Hi,

Thank you for the link!

I can get cell color using the above link, may I know how can I get color of text in the cell, in the below image I got color of cell “Name” and “Color”.

image

I need to get color of text written in “A2:A5” Cells in Color column.

Thank you,
Mirza

4

Hello @Mirza_Hussain
Kindly refer this flow, It may helps you
Forum_CellColour.zip (74.6 KB)

Regards,
Gokul Jai

5

Hi @Mirza_Hussain

Look ingto the video link

Regards
Gokul

6

Hi @Mirza_Hussain

Have a look on the BalaReva Activity

Regards
Gokul

1 Like
7

Hi

Can you please help me showing with workflow for the data I have copied in this topic, as I am a beginner its hard to built a workflow with VBA activity.

Thank you,
Mirza

8

Where do you set the target sheet (‘Sheet1’, ‘Sheet2’, …) ?

Thanks