From personal testing and the documentation found here: https://activities.uipath.com/docs/read-range
The Read Range activity only accepts a string value for the sheet name. I would like to be able to alternatively supply an integer value for the index of the sheet. So, for sheet one, I would supply 0 to denote I want the zeroeth sheet.
In addition, I think it would also be helpful to be able to leave the field blank in order to denote that the first one should be selected.
The reason why this is an issue is because it’s difficult to get the sheet name of a workbook without using an excel scope. At that point, I might as well use the Excel Read Range.
Just to be clear, I am not referring to the Excel Read Range activity, I am talking about the one nested in System > File > Workbook.