I am getting error “Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index” while reading excel file using workbook read range. Tried without giving any range and also by “A1”. nothing worked

Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index

cevdetselcuk (CevdetSelcuk) March 19, 2021, 10:10am 8

The cells should have value. If excel does not have any detail so that it can give error. And please use just double quota -“”- like this read full range.

Read Range: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index