Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am using excel file as a source, but the tab name is not consistant every time.
for example
some time it is coming as
FROM
[$(vFile)]
(ooxml, embedded labels, table is [Employees(1)]);
FROM
[$(vFile)]
(ooxml, embedded labels, table is [Employees(2)]);
etc
Can some one assist me to make it dynamic while loading.
Hi,
This is for files on a directory, but you can try to do something like this
for each File in filelist('..\yourFileDirectory\Employees*.qvd')
LOAD * From $(File) (qvd);
next File
Maybe, if you can do a tablist.... yo can do something like
for each Tab in tablist(File)
LOAD * From $(File) (ooxml, embedded labels, table is [tablist]);
next File
Regads.
thanks for your replay
can I have a sample app for this ..... I dont know if there and tablist() function available in QV.
thanks
Try this
Loading Multiple Excel Sheets Dynamically along with file name and sheet name