Need Condition Statement to Verify Whether Excel Workbook Contains Data or Not

excel
activities
studio

#1

Hai friends,

I need Condition Statement to check entire excel workbook whether the excel workbook contains any data or not i tried the following method in If and Flow decision Statement

variable.Rows(0)(0).ToString.IsNullOrEmpty

But it is not working effectively kindly find the workflow picture and help me out of this thanks in advance.,


#2

Hi @Aravind,

Use Read Cell activity to get the data from the excel sheet and verify the using String.IsNullorEmpty(strvalue)
or
use Read Range activity to get the data from the sheet and store it into Datatable.

DatatableName.rows.count=0

Regards,
Arivu


#3

Hai @arivu96

Thanks for the reply kindly find the image still not working effectively i tried 3 empty excel file out of 3 (2 fail,1pass)

test1


#4

Hi @Aravind,
can you sen the xaml file .


Check DT/Excel sheet contains Data
#5

Sure Mr.@arivu96

Main.xaml (15.2 KB)


#6

Hi @Aravind,

After reading the excel sheet use Output Data Table activity and store it into string variable.
Using if condition check the value
if Condition
variable1.Trim="Column1"

Regards,
Arivu