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?
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.