Excel Validation Confirmation

Help Studio
, ,
2

HI @csanders

  1. Use Use Excel File → Pass the excel file path

Inside the scope

  1. Use Read Range activity → store it as DtRead

  2. Use Look up Range activity

image

  1. Use Find/Replace activity
Excel.Sheet("Sheet1").Range(LookupTotal+":"+System.Text.RegularExpressions.Regex.Match(LookupTotal,"\D+").ToString+(Dtread.Rows.Count+1).ToString)

This will look only in the particular column A1:A+DTread.Rows.Count (example)

image

Check out this XAML file

Find And Replace.xaml (11.2 KB)

Regards
Gokul