How To Change Colour Of Cell During an Iteration

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


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