Excel Replace input value

Help Activities
, ,
1

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.
image
The expected results should be:
image

2

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

3

hey

test.xaml (10.0 KB)
check this example

regards!

4

thanks for your help

5

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