Hi All,
Small question.
Is there such thing as comparing 2 blank cells from 2 data tables? If yes, how can I put it as a condition in If activity?
Thanks a lot
Hi All,
Small question.
Is there such thing as comparing 2 blank cells from 2 data tables? If yes, how can I put it as a condition in If activity?
Thanks a lot
Hi @redbee
String.IsNullorEmpty(row(“Column1”).ToString) or string.IsNullOrEmptywhitespace(row(“Column Name1”)
Thanks
Ashwin S
What if there are 2 column names involved from two different excel sheets?
Hi @redbee
use excel application scope and create a workbook variable
and then use for each item in wb.GetSheets
Pass the item in read range of sheet name and then use if condition based on String.is NullorEmpty(row(“ColumnName1”) or String.is NullorEmptyWhitespace(row(“ColumnName1”) or String.is NullorEmpty(row(“ColumnName2”) or String.is NullorEmptyWhitespace(row(“ColumnName1”)
Thanks
Ashwin S