How to validate if the cell of excel is empty

Help Activities
, , , ,
1

Hello i want to validate a cell empty and after that write in that cell only in the cell empty

i write in an if current Row(book).equals(“”)
but do you know how to implement better this condition

thanks bye

2

Hi @VAZQUEZ_SOSA_LUIS_ALBERTO

You can try with below expression

String.IsNullorEmpty(Currenrow(“YourColumnname”).toString)

Regards

2 Likes
3

Hi @VAZQUEZ_SOSA_LUIS_ALBERTO

welcome to community

Read the cell value(say Read Cell activity) and store in variable e.g.; cellValue . Then using If condition activity, check for string.IsNullOrWhiteSpace(cellValue).

If the current cell is an empty cell, it will recognize it and you can take further action.

also please find below link fr your reference

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.