How to Change The Color of a Specific Row of Excel

Help
, ,
1

Hi everyone,

I want to paint the entire line with the word “Total” in the “Expense” column.

Where should i write this Range area in the properties of Set Range Color activity. Or how can i do that in another way?

image
image1335×563 24.5 KB

2

Hi
–once after getting the datatable named dt pass that as input to FOR EACH ROW activity
–inside the loop use a IF condition like this
row(“Expense”).ToString.Contains(“Total”)
if that is true it will go to THEN part where we can use SET RANGE COLOR activity and mention the range like this
“A”+(dt.Rows.Index(row)+2).ToString+“:”+(Convert.ToChar(dt.Columns.Count+1+65)).ToString+(dt.Columns.Count+1).ToString

this will set that row in to color in excel
Cheers @mazlumkacar

3

Thanks a lot. But i do not understand why are write this inside “range” area.

4

To specify the color at specific row we have to pass expression in range.

Thanks
@mazlumkacar

5

@hasib08 @Palaniyappan but i am getting this error when i try to write it

image
image1134×287 16.1 KB

1 Like
6

Fine
is the variable dt_bfgrup is of type datatable and is passed to FOR EACH ROW activity
@mazlumkacar

7

@mazlumkacar,

use UiPathTeam.Excel.Extensions.Activities, you can easily do it with that package…

Let me know if you need further assistance.

1 Like
8

@sarathi125
i did it with yor way and it is worked. it changed color all of excel page. But I just want to paint the line that says “Toplam Tutar” in the “Gider Çeşidi” column. How should i write in if statement? Where am i do wrong?

image
image1317×716 30.9 KB

@Palaniyappan

9

Use select range activity to select the range you want to color, then use fill color

10

Instead of equals try with contains
row(“yourcolumnname”).ToString.Contains(“your keyword”)

Cheers @mazlumkacar

1 Like
11

@sarathi125 but the range that i want to select is already written in if statement. What should i write inside select range activity? When i choose the “entire row” button, it paint only header row.

image

image
image1188×191 10.2 KB

12

@Palaniyappan i did it but it is not working.

i only need to change format of a row that contains “keyword”. But do not understand why is that not working.

image
image788×730 19.8 KB

When i do that it change the color of all page.

image
image1391×234 13.5 KB

1 Like
14

Did you solve the problem?. Because the thing I’m trying to do is same. Can’t paint the specific row.

15

Hey, Here is the right range code →

"A"+(full_data_table.Rows.IndexOf(row)+1).ToString+":"+(Convert.ToChar(full_data_table.Columns.Count+64)).ToString+(full_data_table.Rows.IndexOf(row)+1).ToString

2 Likes