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

system (system) Closed November 10, 2024, 11:48am 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

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