Excel column empty

[sathish_kumar3 (sathish kumar)]

How to find a particular column is empty in a sheet using assign activity
For eg : column A has value 20
Column B has no value

[Surya_Narayana_Korivipadu]

I found a similar thread.

Read your excel data into a data table and check this.

How to check if a particular column is empty in DataTable (Without using For Each Row)?

for each column in dt if dt.Select(dt.Columns(index or columnname)=dbnull).Length=dt.Rows.Count then msgbox “column is empty” end if next

It may help you