Hello guys, do u know how to replace empty column in excel? i use read range activity
the empty column here is unit
thanks
Hello guys, do u know how to replace empty column in excel? i use read range activity
the empty column here is unit
thanks
The output “Column1” there i want to replace with string like " " or “No Unit”
Hi @Aluneth_X
There are two ways to do that.
Using excel itself
Using a data table
In excel
Within a loop, do a read cell activity to check whether there is any data in that particular cell. If not, use a write cell to replace it with the value you need.
Checking whether it has a value, you can use this code
If activity
Not String.IsNullOrEmpty(Row("ColumnName").ToString)
Assigning a value
Row(“ColumnName”) = “your value”
Good morning Aluneth,
If you’re trying to update the entire column at once, you can accomplish this using Expressions (similar to Excel formulas).
Check out this link for an example: Updating all rows of a column together