Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to get the sheets name out of a lot of excel files. It is working in qlikview but not in Qlik Sense:
QlikView Solution:
sub DoDir (Root)
for each Ext in 'xls' , 'xlsx', 'xlsm'
for each File in filelist (Root&'*.' &Ext)
ODBC CONNECT32 To [Excel Files;DBQ=$(File)];
Sheets:
SQLTABLES;
DISCONNECT;
next File
next Ext
end sub
Call DoDir('C:\Qliksense\TOCs\Lars\') ;
//sense Call DoDir('lib://TOCs/') ; where lib is C:\Qliksense\TOCs\Lars
EXIT Script;
See Qlik Sense's help Example 2
Hi Sonny
The loop is working, it is the " ODBC CONNECT32 To [Excel Files;DBQ=$(File)]; " that does not sesam to work.
Regards
Lars
You have different ODBC for different files?
There is a build-in OBDC driver in Qlik Sense but it seams that it can not be called like in QlikView.
May be, I have not tried this in QlikView of Qlik Sense, may be some one else might be able to offer better help