Get sheet index instead name read range

Hi,

I have Excel file that is updated each month and Sheet name where from I should Read range of rows also shanges its name manthly:
SheetName
For this I used “Read range” activity indicating “Sheet1” in sheet selecting field:
Sheet1
I just assumed that “Read range” should recognize sheet index, but it is getting an error:
Read range does not exists
Can someone advise how can I indicate Sheet index instead of Sheet name in “Read range” activity

This should help:

Just iterate through the indexes and use an if to say if it gets to the index number you want, get that sheet name and store it in a variable and pass that variable in the read range activity.

Use Balareva excel actives Get Sheet Name

Hi,
Use UiPath.Excel.Activities Read Range inside Excel Application Scope activity.