1 Like
I want to update the cell value with zero
1 Like
Sample.xaml (8.2 KB)
You can use ‘Get Cell Color’ activity to get color
Then use if condition to update cell value
3 Likes
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.
1 Like
for the column and row how to keep the counter can you tell???
1 Like
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
===
1 Like
can you share the code or screen shot ??
1 Like
i was getting this error
1 Like
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.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.