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.
Please sign in to leave a comment.