How to check blank colums in an excel?

Help Studio
, ,
2

We assume Excel Data is read in with read range - dtData

Build DataTable Activity: Configure the columns: RowIndex, ColumnName - dtStatistic

Assign Activity
dtStatistic =

(From ri in Enumerable.Range(0, dtData.Rows.Count)
From ci = Enumerable.Range(0, dtData.Columns.Count)
Let v = dtData.Rows(ri)(ci)
Let chk = isNothing(v) OrElse String.IsNullOrEmpty(v.ToString().Trim())
Where  chk
Let ra = new Object(){ri, dtData.Columns(ci).ColumnName}
Select r = dtStatistic.Rows.Add(ra)).CopyToDataTable

Handling empty result we do:
:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum