Accept integer index values in Read Range activity to select sheet

From personal testing and the documentation found here:

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.

Hi @dmccammond
If I understand you correct you are already using the Workbook Activities, so maybe you can retrieve the sheet name using this activity?

By supplying the index, which gives you the sheet name. Then you can use the name in Workbook Get Range.

BR, Martin

That requires that an excel scope is used. I am trying to avoid that.

Hi @dmccammond

Ahh… My bad. I was searching from my phone, so I actually thought I found the activity under System > File > Workbook (and not the Excel Scope). Well then I am on the same page as you with the proposed idea :wink: .

BR, Martin

1 Like

@dmccammond I am looking for exactly similar solution. Because I don’t want to use Excel application scope. So I am using workbook activities. I have a Excel file with 3 sheets and I want to iterate through those sheets. That was possible with excel application scope by using workbook.getsheets. But since I am not using excel scope, how should I get the sheets?

Any idea anyone? Please let me know if you guys get something.

I want to select a range from Excel and copy that. With excel scope, we can use select range but since I am not using excel scope, what should I use instead of select range?

Hello Rucha,

Unfortunately there does not appear to be any news yet. This is a big let down for me too because the workbook Read Range is much quicker it seems.

Thank you for your suggestion. I added it to our internal ideas tracker for our team to consider.