Table (Excel) File question

[#1]

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

[#2]

You can use wildcards in the script...

[#3]

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

[#4]

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 ?

[#5]

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.

[brenner_martina]

Hi,

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

[#7]

Thanks alot - it works !!!

[Miguel_Angel_Baeyens]

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.

[#9]

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

[brenner_martina]

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!