I want to update the value of cell in yellow color to zero

[kalyan.vadala]

[JIHUN]

Please use “Set Range Color” activity

[kalyan.vadala]

I want to update the cell value with zero

[Dongjin_Lee]

Sample.xaml (8.2 KB)
You can use ‘Get Cell Color’ activity to get color
Then use if condition to update cell value

[Thom_Co]

I assume you want to look through every cell and change the values to zero?

You need an excel scope and read range activity to generate your datatable.
Then use a ‘for each’ activity to look at every row, from which you can look at every column index with an IF check and change the value to 0 if it finds a number.
Once the check has completed, write the datatable back into the excel file.

If the column count is not known, you can use YourDT.Columns.Count -1 to determine the max. index number. Then you can add a counter within the ‘for each’ activity to run through every column from index 0 to YourDT.Columns.Count -1.

If there is a color check, @Donglin_Lee 's solution will work.

[kalyan.vadala]

for the column and row how to keep the counter can you tell???

[Thom_Co]

If you have all the checks within a ‘for each row’ activity, you can do the following

Before ‘for each row’ activity:

• Assign ‘col counter’ to 0

===
During ‘for each row’ activity:

---

'Do While activity for ‘col count’ <> YourDT.Columns.Count - 1

• IF check on column index for cell value > 0 and then the resulting activities of true and false
• ‘col counter’ = ‘col counter’ + 1

---

===

[kalyan.vadala]

can you share the code or screen shot ??

[kalyan.vadala]

i was getting this error

[Thom_Co]

Screenshot above. If you are still lost about what I have done, I’ll strongly recommend going to the UiPath Academy. You will learn many of the DataTable and Excel related activities and codes from the Foundation course.