Hello everyone!!
How do I check if one of the sheets of excel is null
1 Like
You can use Read Range activity and then check as
using If condition
Dt.Rows.Count > 0
Hope this will help you
Thanks
1 Like
Hi @Rntss23 ,
Did you mean to say, that after reading the Sheet, you wanted to validate whether the sheet contains data or not?
Could you try this and let us know if it works out for you?
If(IsNothing(Dt) OrElse Dt.Rows.Count.Equals(0),True,False)
Kind Regards,
Ashwin A.K
1 Like
It worked
Thanks guys for the support
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.