How to detect an empty column in excel?

[sreekanth]

Refer this @vivek_Chowdary,

Check which excel field is empty for imputing data

You can do this check on a Loop (For Each Row activity). With in that foreach, you will need an "If " activity to check: row.item(“ColumnName”).ToString() = “” or row.item(“ColumnName”) = nothing If match found, assign the value in to that cell using Assign activity.