How to check Excel blank or not in different sheets

How to check Excel blank or not in different sheets

Thanks
Shaik

Hey @shaik.muktharvalli1
1 : Read your excel variable : input_dt
2 : add if condtion

if input_dt.rowcount > 0
     perform further
else
     exit

hi @shaik.muktharvalli1 ,
you need to find a rule to test,
Is there any relationship between the starting position of each sheet’s data?
If they are the same, we can read from a different header cell then use “find last row” which will give us the result ‘inlastrowcount’
Check this variable if it is less than 1 we conclude it is empty
For more details you can send sample file, I will test it
Regards,
Luong

Use activities : Excel Process Scope → Use Excel File → For Each Sheet in Excel → Read Range and get data in datatable - dtSheet. Now, in Assign take int32 variable to get “dtSheet.RowCount” value.