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 ?