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

Follow

Nikhil Srinidhi

• October 05, 2016 21:59

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.

 

0

• 

  Steve Egan

  • October 06, 2016 02:42

  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

  Comment actions Permalink

Please sign in to leave a comment.