Read range empty values

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. :slight_smile:

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.


1 Like