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

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

Hi @Sanchit7

Is the excel sheet able to view ?

Thanks
Ashwin S

Hi @Sanchit7

Index was out of range usually it will give error when your sheet name or the range of the cells are given wrong, it is better to show what you are trying to automate, so that we can check

Thanks

Yes, when I use Read Range withing excel application scope, the bot stays in running mode and never stops nor gives any error. When I use workbook read range, it says index was out of range. Please help me