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
But it is not working effectively kindly find the workflow picture and help me out of this thanks in advance.,
Use Read Cell activity to get the data from the excel sheet and verify the using String.IsNullorEmpty(strvalue)
use Read Range activity to get the data from the sheet and store it into Datatable.
Thanks for the reply kindly find the image still not working effectively i tried 3 empty excel file out of 3 (2 fail,1pass)
can you sen the xaml file .
After reading the excel sheet use Output Data Table activity and store it into string variable.
Using if condition check the value