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.


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


Have you checked Add Headers option or not ?

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

1 Like


Glad to help you. Happy Automation :grinning:

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