Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop on excel sheets in qlikSense Script ?

Hi all,

I need to loop on all the sheets of all Excel files in a given folder.

I used the jet provider solution found on the forum in Qlikview :

CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source="$(File)";Extended Properties="Excel 8.0;"];

But it doesn't work with QlikSense. Do you know how to handle that ?

Thanks

1 Reply
Not applicable
Author

Actually I should have digged a little bit before asking, it's simple :

ODBC CONNECT To [Excel Files;DBQ=$(File)];

Then load the SQLTables:

tables:     

  SQLtables;

then loop in this table.