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