How to check if there is any data in Excel

Help Activities
1

only want to check if the sheet is empty or not

3

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

4

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.

image
image702×485 19 KB

5

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)

Regards