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
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.