How to check if an excel file is empty?

Help
, ,
1

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

2

@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
3 Likes
4

@HiteshJeswani101

Have you checked Add Headers option or not ?

5

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

1 Like
6

@HiteshJeswani101

Glad to help you. Happy Automation :grinning:

7

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