I have an excel sheet with two tabs. I need to check a value that existing in sheet1, if its not existing then need to verify the same value against sheet2.
converted the excel in to two different datatable for sheet1 and sheet2. Tried some solutions buts its not working.
I suggest to convert both sheets into separate datatable: “DT1” and “DT2”
Use twice activity Output data table where: Input will be “DT1” or “DT2” and Output “DT1text” or “DT2text”
And you can use IF conditions to check if your value exist in first or second sheet
DT1text.ToString.Contains(“yourvalue”)
or
DT2text.ToString.Contains(“yourvalue”)