How to check multiple columns have data in Excel file

as you have mentioned multiple rows, we would recommend to further define the report level

  • row wise
  • data table wise

For data table wise:

Build DataTable Activity

  • Confige an empty datatable with 2 cols: RowIdx | String, ColName | String - dtReport

Assign Activity
dtReport =

(From i in Enumerable.Range(0, dtOrig.Rows.Count)
Let d = dtOrig.Rows(i)
From c in Enumerable.Range(0, dtOrig.Columns.Count)
Where isNothing(d(c)) OrElse String.IsNullOrEmpty(d(c).toString.Trim)
Let ra = new Object(){i.ToString,dtOrig.Columns(c).ColumnName }
Select r = dtReport.Rows.Add(ra)).CopyToDataTable

Handling empty result (e.g. no blanks are detected)
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum