How to check Excel file empty or not

[shaik.muktharvalli1 (shaik muktharvalli)]

How to check Excel file empty or not for all sheets

Thanks
shaik

[vrdabberu (Varunraj Dabberu)]

HI @shaik.muktharvalli1

Check below threads:

How to check if an excel file is empty?

@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

Check if excel file is empty

Hi, Do you need to check if the sheet is empty or not? If so, the following will help you. [image] Regards,

Regards

[jawagarraja123]

Hey @shaik.muktharvalli1
Read excel File
and Add the if conditions

If Dt_Input.RowCount = 0 Then
Exit Sub
Else
’ Perform further actions
End

Cheers

[rmorgan]

Theres a count rows activity

[shaik.muktharvalli1 (shaik muktharvalli)]

but their different sheet names and unstructured headers.

screenshot for your reference:

Thanks
Shaik