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



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


How can the robot check for blank cells or cells who contain 0 in Excel table?

Thank you . I will try this