Use sheet index for sheet name in sharepoint excel read range

[adext]

Hello

I would like to use the sheet index instead of the sheet name because it changes all the time

How can I achieve that ? Thanks

[Shiva_Nikhil]

@adext

Can you check the datatype of getsheets

[adiijaiin (Aditya Jain)]

hi @adext

You can give the index as well if you have all the sheet names in GetSheets variable.

You have to write the expression as

Excel.Sheet(GetSheets(0))

Thanks

Happy Automation!

[ashokkarale]

@adext,

Try this way.

1. Use For Each Sheet in Workbook activity
2. Inside it, check CurrentItemIndex is same as your desired sheet index
3. If step 2 true then do the Write Cell this way.

Full solution:

Thanks,
Ashok