topic Re: How to load first tab of xls without using the tabname in QlikView

How to load first tab of xls without using the tabname

lmonincx — Wed, 09 Apr 2014 08:38:45 GMT

Hi,

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:

TableX:

load

@1 as CustomerName,

@2 as CustomerNumber

from

[@data\*filename01.xls]

(biff, no lables, table is [abc$] );

I want the reference of [abc$] to look at the first tab /sheet.

Hope this will be possible.

Kind regards!

Linda Monincx

tresB — Wed, 09 Apr 2014 08:46:15 GMT

You can try creating ODBC connection and then like:

ODBC CONNECT32 TO [Excel Files;DBQ=$(vReportDefinitions)];

SpreadsheetData:

SQLTABLES;

DISCONNECT;

Let zSheet = Peek('TABLE_NAME', 'SpreadsheetData')

LOAD *

FROM $(vReportDefinitions)

(ooxml, no labels, table is [$(zSheet)]);

Wed, 09 Apr 2014 09:15:31 GMT

Try this,

(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.

Thanks,

Prabhu

rohit214 — Wed, 09 Apr 2014 09:40:07 GMT

try this

from

xyz.xls

(biff, embedded lables);

Thanks

rohit