Discussion board where members can get started with QlikView.
I am wondering if there is a way to load the first sheet from an xlx file.
Reason is that customer is contantly changing the name of the tab.
Now i have:
@1 as CustomerName,
@2 as CustomerNumber
(biff, no lables, table is [abc$] );
I want the reference of [abc$] to look at the first tab /sheet.
Hope this will be possible.
You can try creating ODBC connection and then like:
ODBC CONNECT32 TO [Excel Files;DBQ=$(vReportDefinitions)];
Let zSheet = Peek('TABLE_NAME', 'SpreadsheetData')
(ooxml, no labels, table is [$(zSheet)]);
(biff, no labels, table is @1);
This reads the 1st sheet.
However this method works only for .xls files. For .xlsx you may have to follow tresesco answer.
(biff, embedded lables);