Automation Excel

Help Studio
, ,
1

I want to create a senerio where I’m trying to color the first four columns of an excel sheet with ‘Blue accent 1’ color without using macros. How to do that.

Thanks

2

Hi @Ashish_Kina, welcome to the Community.

You can use the Format Cells activity to achieve the same:

image

Hope this helps,
Best Regards.

3

Hi Arjun
In Fill option of Format Cell the color that i want to use is not present–‘Blue Accent 1’.
Thanks for your reply.

4

Hi @Ashish_Kina,

Try using balareva excel activities.

5

@Ashish_Kina

If it is always the first four columns that you need to color…then create a template with that format and use that always and write the data to that template always…

Hope this helps

Cheers

6

Hi @Ashish_Kina Please check the below link

How to set color or get color from a cell in excel UiPath - RPA Learners

7

Hello @Ashish_Kina , Welocome to UiPath Community.
Refer to this Video, you will get some ideas.

8

Thanks for your response. In the set range color activity the color that I want to use is not present (Blue,accent 1)
Ex. System.drawing.color.Blue accent 1 is not there .

But I solved this problem by assigning the RGB value in a variable and then pass the variable to the set color range .

Thanks