Read range empty values


#1

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:


#2

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