getting the name of a loaded TABLE from an Excel file

[#1]

Hello,

Do you know any idea of getting the name of table loaded from an Excel file? Similar to filename() as File.

I have a spreadsheet with multilpe sheets, if I leave "table is" then all sheets are laoded, I would however need to know from which sheet data was retrieved.

LOAD

Comments,

TableName() as Table (???) - doesn't work

FROM
[..\Desktop\SE17.xlsx]
(ooxml, embedded labels, header is 3 lines

);

[#2]

Hi,

is the structure of metadata the same for all sheets?

If so, one way would be to create ODBC connection to excel file and read name of each sheet (as it was proposed in the answer of http://community.qlik.com/message/223895#223895 post). Now, in load statement you can add new field, e.g. '$(zSheet )' as sheetName. Value of that field provides information from which sheet row was read.

regards