How to get excel sheet names

[neelamsaroha157]

Hi everyone,

I know it might be pretty straight forward but I have no idea.

I want to get all the sheet names of an excel and use them as column.

Is there any direct function to get it??

Appreciate your help.

[m_woolf · Accepted solution]

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[neelamsaroha157]

ohhhhh..its not that straight forward

Thanks for your reply @m w.

I'll mark it correct if I don't get any simpler way to do it