Please i want to know how to check the data in one colum in excell sheet , if it s null or not
Please follow the below steps:
- Read Excel file
- Apply Loop using For each row activity
- Inside “If” activity you just have to check this condition-
row.item(“ColumnName”).ToString = “”
You can also use the condition “row(“Column”).ToString = nothing” in ‘if activity’.
If you have more than one column to check, append the conditions with an ‘or’ statement. ie, row(“Column1_Name”).ToString = nothing or row(“Column2_Name”).ToString = nothing etc.
I think we need to check the row.item(“ColumnName”) is Null or not at first, otherwise it will cause NullException.