Using Excel Loop Activity and sending blank excel with Headers only

Hello Team,

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.

Hi,

if you are using try catch then exception for blank row will pass execution flow to catch block where you can log or write the exception and then proceed with remaining part of use case

Regards,
Amit Anand