Insert Excel Sheet name into a Field

[#1]

Hi everybody,

I'm uploading several Excel files in Qlik Sense. I know their name and I don't want to loop over all files, but just to read the name of the sheets (I don't know if I've been clear, for file I mean test.xlsx and the sheets are within the file like Sheet1, Sheet2,...) in order to put them in a field.

So I've got this situation:

[Table1]:

LOAD *

FROM [lib://Desktop\test.xlsx]

(ooxml, embedded labels, table is Sheet1);

and I want to read "Sheet1" and put it in a field.

How could I do it? I tried with different macro using the ActiveDocument.ActiveSheet.GetProperties.Name method, but I did'n get what I wanted.

Thanks a lot for your help,

best regards

Nicolò Cogno

[pentaxadmin]

I am having similar issue. When trying to use TableName fx, only first sheet is populated. I checked table name on the load and do not see any values. Almost seems like there is an issue with the format. I see you guys are using ODBC to connect to excel. Do you think that connecting directly to *.xlsx may be causing this issue?