Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need to load all the sheets in excel at time ?

HI All,

I am having months data in the Excel Sheet.

Every month it will added one more Sheet With new month, need to be loaded in a Single load dynamically.

Please find the attached excel, Can any help me on this..

Regards,

Helen

11 Replies
effinty2112
Master
Master

Helen,

Let vXLSPath='PathToFileIncludingFilename.xlsx';

ODBC CONNECT TO [Excel Files;DBQ=$(vXLSPath)];

     Sheets:

     SQLTABLES;

     DISCONNECT;

for i = 0 to FieldValueCount('TABLE_NAME') -1

Let vTablename = Left(Peek('TABLE_NAME',$(i)),len(Peek('TABLE_NAME',$(i)))-1);

Data:

LOAD *

FROM

$(vXLSPath)

(ooxml, embedded labels, table is [$(vTablename)]);

Next i;

DROP Table Sheets;

alextomlins
Contributor III
Contributor III

Hi Andrew Walker - I'm getting an error for the ODBC connection. I'm on Qlik Sense Enterprise....Do you know what it could be out of chance? ;

The following error occurred:

CONNECTs other than LIB CONNECT are not available in this script mode.