1 Reply Latest reply: Oct 2, 2015 1:12 PM by Vincent CADORET RSS

    Loop on excel sheets in qlikSense Script ?

    Vincent CADORET

      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