Load multiple (and unknown number of) sheets from Excel into QlikSense

salto — Mon, 25 Apr 2022 12:46:17 GMT

Hello,

we are moving from Qv to QS, and we have found another issue: we are reading sheets from different Excel files. We don't know the number of sheets or their names, so we are using this piece of ocde in QlikView that owrks like a charm:

for each file in FileList('\\qlikserver\Excel_Sources\SourceFile.xlsx')
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];

temp_tables:
SQLtables;
DISCONNECT;

This creates a table (temp_tables) with the names of all the sheets in the SourceFile.clsx in the TABLE_NAME field.

The issue is that this is not working in QlikSense: I have not been able to re-create the connections as LIB connections and make this work. I have tried with this but nothing good happens:

for each file in FileList ('[lib://qlikserver\Excel_Sources\SourceFile .xlsx]')
LIB CONNECT TO 'Excel)'; //no place for DBQ=$(file)];?

Has anyone faced this before?

Thanks in advance.

topic Load multiple (and unknown number of) sheets from Excel into QlikSense in Connectivity & Data Prep

Load multiple (and unknown number of) sheets from Excel into QlikSense