Excel tab name is not consistant

[dsharmaqv]

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.

[enriquem]

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.

[dsharmaqv]

thanks for your replay

can I have a sample app for this ..... I dont know if there and tablist() function available in QV.

thanks

[enriquem]

Try this

Loading Multiple Excel Sheets Dynamically along with file name and sheet name