How to update excel status as pending or done based on excel cell details?

Hi All,

Use Case : Update the Status as Pending or Done based on the excel cell empty or not.


So, I have read the excel file using read range workbook activity. But couldn’t build a logic for “if Condition” .


Please help me with the logic.

Thanks in Advance:-)


Try this

IsNothing(Row("ColumnName")) OrElse String.IsNullOrEmpty(Row("ColumnName").ToString) OrElse String.IsNullOrWhiteSpace(Row("ColumnName").ToString)

Till with check for null…empty and whitespace


Hi @Vaishnav_Tej ,

Try this, I hope this works for you. (10.0 KB)

Vinit Mhatre

1 Like

Thank you for your immediate response.



These 2 conditions are working correctly.

Could you please help me with any document/link to learn such type of logic building.


You can use whole of the statement together as well same using OrElse

You will get familiar with them as you use…

Try browsing throgh this


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