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.