Use sheet index for sheet name in sharepoint excel read range

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

image

@adext

Can you check the datatype of getsheets

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! :smiley:

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

image

Full solution:

Thanks,
Ashok :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.