Renaming Excel Sheet Without Knowing Name

[jpreziuso]

I am using the modern excel activities and would like to use the Rename Sheet activity. However, I do not know the sheet will be named after the download of the Excel file, so I would like to reference it as the first sheet (sheet 0) and then change the name that way.

Is this possible? Thanks

[Shiva_Nikhil]

@jpreziuso

It is possible to rename the sheet only if the mentioned name in the rename Sheet exists

other you cannot imagine what the name of the sheet it will come when you download

[Vikas_M]

Hey @jpreziuso ,
You can use below activity

It will take the index as an input and outs the column name

Hope it helps you!

[mkankatala (Mahesh Kankatala)]

Hi @jpreziuso

In modern activities there is an activity called For each excel sheet activity which iterates the sheets in the excel.
Inside the For each excel sheet activity you can get the name of the column.

Check the below workflow image for better understanding.

Hope it helps!!