Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Have a look here: Re: How to load from variable table name
Removing the "Table Is XXX" from your load will force the first tab to be loaded, I think.
(ooxml, embedded labels);
to change the sheet only need to change value for first sheet 1$,second sheet 2$ ....
(biff, embedded labels, table is Sheet1$);
you can chose header row also by using header size as lines and then chose the line.