Get sheet index instead name read range

[Apple1]

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:

For this I used “Read range” activity indicating “Sheet1” in sheet selecting field:

I just assumed that “Read range” should recognize sheet index, but it is getting an error:

Can someone advise how can I indicate Sheet index instead of Sheet name in “Read range” activity

[SenzoD (Senzo Dlomo)]

This should help:

How To Get The Sheet Name From Excel – In UiPath

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.

[Matt_S]

Use Balareva excel actives Get Sheet Name

[indiraprakash (Prakash)]

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