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!
Glad to help you. Happy Automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.