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.
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
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
Retrieving data ...