How to check if there is any data in Excel

only want to check if the sheet is empty or not

Use the get range activity, if it throws an error, the sheet is empty

Hi @Nightowl_music ,

Just uncheck headers property and in range give it as “”.
It will read the excel and if sheet is empty the dt count will be 0.

Hi @Nightowl_music

Please refer to the xaml below.

I have done with multiple Excel sheets if the sheet is empty it will Pop message box as Empty and if the sheet Contains Any value in it pop message box as “Not Empty”

SheetIsEmptyOrnot.xaml (8.1 KB)