Hi, Can anyone tell me how to change specific excel row color using linq in UiPath studio. Please share your thoughts

@Nisha_K21 , You can use Set Range Color activity to change excel row color. Find row index rowIndex = dt.AsEnumerable().Select(Function(row, index) New With {row, index}).Where(Function(x) x.row(“ColumnName”).ToString = “SomeValue”).Select(Function(x) x.index + 2).FirstOrDefault() Use Set Range…

Change excel row color

Help Something Else

Gowtham_K115 (Gowtham Krishnan) November 7, 2024, 11:17am 2

Hi @Nisha_K21

Refer the below video,

https://www.youtube.com/watch?v=EGXkGFx1yyc

Try this activity

Regards,
Gowtham K

1 Like

Topic		Replies	Views
Change cell color if row.item(0) > 500 Studio	4	1055	September 8, 2021
How to highlight last row in excel? Help datatable , excel , activities , question	5	1693	November 26, 2019
How to Change The Color of a Specific Row of Excel Help excel , activities , question	13	4600	January 26, 2021
How to change the excel cell value colour in uipath?(not background colour) Studio studio , question , activities_panel	2	1422	June 1, 2022
Underline cell in excel Help datatable , excel , studio	10	1818	October 25, 2019

Change excel row color

Related topics