Is it possible to capture name of excel sheet when importing data?

2 followers
0
Avatar

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.

 

Nikhil Srinidhi

1 comment

  • Avatar
    Steve Egan

    The current excel importer does not support having sheet names as metadata. Your best option at this point would be to add the column containing the literal in a workbook once imported.

    0
Please sign in to leave a comment.