Modify Data in an datattable


I have a column
col1 col2 col3 col4 col5

In this col1 whtever the different value is i need to color it but “All” and “S” Should be consider as same.

How to do it plss help


Write Range activity to write to the excel

After that Read Range to read the excel and use For Each Row activity

Place If condition and check as below

row(“col1”).ToString <> “All” OR row(“col1”).ToString <> “S”

Then->Use Range Color
Else → Blank

Hope this may help you



Hope the below steps would help you resolve this

Say you want to Color all the values in red and “ALL” - “S” in yellow Color

  1. Use a excel application scope and pass the file path as input

  2. Inside the scope use a read range activity and get the output as dt

  3. Now use a FOR EACH ROW activity and pass dt as input

  4. Inside the loop use a IF activity like this

CurrentRow(0).ToString.ToUpper.Contains(“ALL”) or CurrentRow(0).ToString.ToUpper.Contains(“S”)

If true it goes to THEN block where use a SET RANGE COLOR activity

And mention the properties like this

Range - Convert.ToChar(65+dt.Columns.IndexOf(“col1”)).ToString+(dt.Rows.Indexof(CurrentRow)+2).ToString

And Color as

If it’s false it goes to ELSE BLOCK where use the same set of activities ur Color alone as System.Drawing.Color.Red

Cheers @Doonline

no I need to Compare it first then need to color it.But while comparison itself i need to make it as equal.Then only in comparison condition it will take is as same

May I know what to compare with which value