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