Compare Blank Cells from 2 different Data Tables

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 :slight_smile:

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