Use sheet index for sheet name in sharepoint excel read range


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



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



Happy Automation! :smiley:


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:

Ashok :slight_smile:

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