Hi All, Use Case : Update the Status as Pending or Done based on the excel cell empty or not. [image] So, I have read the excel file using read range workbook activity. But couldn’t build a logic for “if Condition” . [image] Please help me with the logic. Thanks in Advance:-)

@Vaishnav_Tej 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 cheers

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

Help Studio

Anil_G (Anil Gorthi) December 28, 2022, 5:57pm 5

@Vaishnav_Tej

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

Cheers

Topic		Replies	Views
If condition issue Help	2	1317	July 9, 2018
Checking whether certain cells have been filled in an excel sheet Studio	3	905	February 18, 2020
How to validate if the cell of excel is empty Activities excel , robot , activities , studio , question	3	5752	February 10, 2022
Condition in database read row from empty row Activities database , activities , question	5	72	November 15, 2024
How to do an Excel ReadCell/WriteCell sequence WHILE cells are not either empty or specific text? Help	5	748	October 8, 2019

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

Related topics