Check if excel is empty

[seldo]

hello,

Below you find my current workflow and excel file. I need to check if the file (except the headers are empty). other solutions didn’t seem to work. Or I did something wrong.
any ideas?

[RobertD (Docan Robert)]

Replace your condition with InvoiceNr.Rows.Count > 0 in the if statement.

[amagdy529 (Ahmed Magdy)]

u can read range in a datatable
and then get the rows count in the data table ,just as the below code

DT_DataTableName.Rows.Count

if the count equals zero then the file is empty