Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Tags (1)
1 Reply
Not applicable

Re: Loop on excel sheets in qlikSense Script ?

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.

Community Browser