How to check if an excel file is empty?

I want to check if an excel file is empty or not and perform operations accordingly.

@HiteshJeswani101

Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’. And then check below condition.

   IF DT.Rows.Count > 0
   Then it has data 
   Else no data

@HiteshJeswani101

Have you checked Add Headers option or not ?

Yes this worked. Thank you so much @lakshman for your help! :slight_smile:

1 Like

@HiteshJeswani101

Glad to help you. Happy Automation :grinning:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.