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.
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?
