I am using Excel Loop activity to fetch data in excel file. But if empty excel with only headers is passed, it gives error “Index was outside the bounds of array”
I have used try catch also to catch this error.
Could you please assist if there is way to check initially if the excel is blank or not ?
Is there any way I can get count of data even before going inside loop ?
Thanks In advance.