Want to Excel sheets upload at a time..

[#1]

Hi Community.

   I have an Excel sheet , which contains 5 tabs.

   We can select each tab every time to upload data into qlikview.

    But

    Is there any other  way to upload All tabs at a time into qlikview ???

Thanks and Regards

Satti 

[#2]

try this

Load *

From $(Path)\*.xls

(biff, embedded labels, table is Sheet1$);

[Gysbert_Wassenaar]

See here.

[#4]

you can also try like er.

for each vSheet in 'Sheet1','Sheet2','Sheet3'

a:

load *

FROM

C:\Users\admin\Desktop\Book2.xlsx

(ooxml, embedded labels, table is $(vSheet));   

Next vSheet;

[#5]

Hi Gysbert,

Could you please attach sample Application .

Thanks and Regards

Satti