Hi,
I am using a for each row activity, I want to change the colour of each cell after every iteration.
How can this be done?
1 Like
Use Set Range Color activity to set the color to excel cells and you need to pass the range of the cells.
how to get the range of the cells?
Suppose you want to apply colors to D column.
ForEach row in inputDT
int index = inputDT.Rows.IndexOf(row) + 2
Range: "D"+index.Tostring
Where inputDT is your input dataTable.
If Excel file contains headers then use +2 else +1
6 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.