How to check if a column is empty?

Hi there . I want to enter values in a certain column in an excel document , but only if the certain column is empty . how can i check if a column is empty? Thank you

1 Like


You can do this check on a Loop (For Each Row activity). To do this you’ll need a "If " activity.

Then you just have to check:

row.item(“ColumnName”).ToString() = “” or row.item(“ColumnName”) = nothing



Thank you . I will try this