Is it possible to capture name of excel sheet when importing data?2 followers
I have a workbook with 12 sheets (Jan, Feb, Mar, ... Dec)
Is it possible to somehow capture the name of the sheet as a column? Right now only the .xlsx workbook name is available as meta-data...
So if i am importing a sheet : "Jan" I want a column populated with "Jan" in every cell.