Excel Replace input value

Hi, I have got some data in the excel. If the number exceeds 3, then it should be adjusted to 3. Could someone suggest some solutions? Thank you.
The expected results should be:

give a try on following flow:

  • Excel Application Scope - read range: dtData
  • for each row activity | row | dtData
    • if Activity: Condition:
      IsNothing(row(YourColNameOrIndex)) OrElse String.IsNullOrEmpty(row(YourColNameOrIndex).toString.Trim)

Then Branch: nothiong to do
Else Branch: assign activity: row(YourColNameOrIndex) = If(Cint(row(YourColNameOrIndex)) > 3, 3, row(YourColNameOrIndex)

Finally: write range activity and writing datatatable dtData back to the excel


test.xaml (10.0 KB)
check this example


thanks for your help

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.