Open the Excel sheet index 1

[Soudios (Sou)]

The name of excel sheet change every time, i need to open every time the first sheet by using read range activity

[Rahul_Unnikrishnan]

Hello @Soudios

Plz refer to the below post.

Read range Excel sheet index

Hi, I would like to use the readrange activity to read range from an excel file. [image] Is there any way to refer to the index of the sheet instead of the name of the sheet? I have to read range from the first sheet of the excel file, but the name of the sheet always refers to the user’s name, so that is always different. Could you please help me?

Thanks

[Jose_Cunha (José Cunha)]

Hello.

Try this:

Use excel application scope activity
create output variable from the property eg: WB
Then use Read range and in the sheet pass like this wb.GetSheets(1)

Hug