How to check if a column is empty?


#1

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


#2

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,


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

Thank you . I will try this