topic Re: Qlik Sense, Loop excel sheets names. in QlikView

Qlik Sense, Loop excel sheets names.

lars_plenge — Fri, 24 Feb 2017 13:34:39 GMT

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;

sunny_talwar — Fri, 24 Feb 2017 13:38:24 GMT

See Qlik Sense's help Example 2

lars_plenge — Fri, 24 Feb 2017 13:45:00 GMT

Hi Sonny

The loop is working, it is the " ODBC CONNECT32 To [Excel Files;DBQ=$(File)]; " that does not sesam to work.

Regards

Lars

sunny_talwar — Fri, 24 Feb 2017 13:48:35 GMT

You have different ODBC for different files?

lars_plenge — Fri, 24 Feb 2017 21:15:06 GMT

There is a build-in OBDC driver in Qlik Sense but it seams that it can not be called like in QlikView.

sunny_talwar — Sun, 26 Feb 2017 15:51:01 GMT

May be, I have not tried this in QlikView of Qlik Sense, may be some one else might be able to offer better help