Read range empty values

[CamiCat]

Hello friends,
when I try to read an Excel Sheet which is empty I get the following error:

How is it possible to use the Read Range Activity also for an Empty Excel Sheet without having an exception?
Maybe with an If condition?
Thank you so much,
Camilla.

[niteshn (Nitesh)]

Hi CamiCat - Yes, you can use if condition. The condition you need to check is (DataTableName.Rows.Count>0) or just use read range within ExcelScope Activity to avoid this error.

Thanks,
Nitesh