topic Re: Loading the first tab from an XLSX in QlikView

Loading the first tab from an XLSX

struniger — Thu, 27 Nov 2014 16:25:37 GMT

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

marcus_sommer — Thu, 27 Nov 2014 16:51:27 GMT

- Marcus

ThornOfCrowns — Thu, 27 Nov 2014 17:02:22 GMT

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);

Thu, 27 Nov 2014 17:46:48 GMT

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.