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

Hello!

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

Regards,

4 Likes

Thank you . I will try this