Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

djlagaffe
Contributor

Loading the first tab from an XLSX

Hi all,

I get an XLSX File with a known structure per tab, but I don't know how the tabs are called.

I have to make sure I always load the first tab.

This works nicely with XLS files using 'table is @1' but this is not possible with XSLX.

I tried reading the tabs via ODBC (according to How to load first tab of xls without using the tabname) but don't see a way of identifying the first tab.

Any idea, hint or help would be appreciated.

Thanks

Stefan

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Loading the first tab from an XLSX

Have a look here: Re: How to load from variable table name

- Marcus

3 Replies
MVP & Luminary
MVP & Luminary

Re: Loading the first tab from an XLSX

Have a look here: Re: How to load from variable table name

- Marcus

thornofcrowns
Valued Contributor II

Re: Loading the first tab from an XLSX

Removing the "Table Is XXX" from your load will force the first tab to be loaded, I think.

E.G.

LOAD *

FROM

(ooxml, embedded labels);

Not applicable

Re: Loading the first tab from an XLSX

to change the sheet only need to change value for first sheet 1$,second sheet 2$ ....

FROM

abc.xls

(biff, embedded labels, table is Sheet1$);

you can chose header row also by using header size as lines and then chose the line.