Loading the first tab from an XLSX

[struniger]

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 · Accepted solution]

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

- Marcus

[ThornOfCrowns]

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

[#4]

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.