Excel Empty Cell Detection

[Daun (Daun Lee)]

Is there a way in UiPath of checking whether a specific cell has no value in it?
I’ve looked other postings but haven’t found a solution yet.
Please try with the attached.

Sample Columns.xlsx (10.5 KB) Main.xaml (10.6 KB)

[Jan_Brian_Despi]

Hi @Daun

You can simplify your workflow.
Use For Each Row instead since you are working with data tables.
Then to check if a cell is empty, just use String.IsNullOrEmpty(CellValue.ToString) in the condition

[Jan_Brian_Despi]

Please try this one:
Main.xaml (11.8 KB)

[Daun (Daun Lee)]

[Jan_Brian_Despi]

Kindly check the revised xaml file that I sent

[Palaniyappan (Forum Leader)]

no worries
i have just made few changes in your workflow in the condition part and inside ELSE part of the if condition
you were almost done
hope this would help you
kindly try this and let know for any queries or clarification
daun.zip (19.4 KB)

Cheers @Daun

[Daun (Daun Lee)]

String.IsNullOrEmpty(CellValue) worked instead of
String.IsNullOrEmpty(CellValue.ToString)

Strange that we have to put integer not String within the paranthesis even though the method name is String.IsNullOrEmpty.

@Jan_Brian_Despi @Palaniyappan
Thank you!