Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use wildcards in the script...
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
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 ?
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.
Hi,
I tried to use wildcards for the sheetnames, it does not work!
Thanks alot - it works !!!
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.
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);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!