topic AW:Re: Table (Excel) File question in QlikView

Table (Excel) File question

Mon, 05 Jul 2010 12:32:23 GMT

Hi,

Is there a way to load an Excel file where it's table name changes from time to time without changing the script ?

what i'm trying to ask is if there is a way to load a sheet from excel by reffering to it's location rather than it's name.

Thanks a lot

Ron

Table (Excel) File question

Mon, 05 Jul 2010 12:43:21 GMT

You can use wildcards in the script...

Table (Excel) File question

Mon, 05 Jul 2010 12:48:02 GMT

From Help

The filename may contain the standard DOS wildcard characters ( * and ? ). This will cause all the matching files in the specified directory to be loaded

Table (Excel) File question

Mon, 05 Jul 2010 13:17:33 GMT

First, thanks for your answer.

can I use wildcard characters in the sheet name also ?

for example, instead of writing:

FROM (biff, no labels, table is FileName$);

can I write

FROM (biff, no labels, table is *);

and if I can, if there will be more then one sheet in the Excel file, how does Qlikview will know from where to import the data ?

Table (Excel) File question

Mon, 05 Jul 2010 14:32:48 GMT

If the sheet to load is the first in your Workbook, you can omit argument "table is" and QV will asume that the data is in the first sheet.

AW:Re: Table (Excel) File question

brenner_martina — Mon, 05 Jul 2010 14:38:09 GMT

Hi,

I tried to use wildcards for the sheetnames, it does not work!

Table (Excel) File question

Mon, 05 Jul 2010 14:58:00 GMT

Thanks alot - it works !!!

Table (Excel) File question

Miguel_Angel_Baeyens — Mon, 05 Jul 2010 16:39:34 GMT

Hello Ron,

Using @1, @2, @3... will do as well as table name (fist, second, third...) in the workbook, in case it's not the first sheet.

Regards.

Table (Excel) File question

Mon, 12 Jul 2010 07:25:41 GMT

Thanks a lot.

just to make sure i understand - if this is the second sheet in the Excel file, I should write

FROM

[???.xls] (biff, embedded labels, table is @2);

AW:Re: Table (Excel) File question

brenner_martina — Mon, 12 Jul 2010 08:05:01 GMT

Hi,

for Excel 2003 it is: ...(biff, ... table is @2$) ....;

for Excel 2007 it is: ... (ooxml, .... table is @2) ...;

and nobody has to change the order of the sheets in the file!