topic Re: Want to Excel sheets upload at a time.. in QlikView

Want to Excel sheets upload at a time..

Mon, 06 May 2013 11:13:24 GMT

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

Mon, 06 May 2013 11:18:12 GMT

try this

Load *

From $(Path)\*.xls

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

Gysbert_Wassenaar — Mon, 06 May 2013 11:18:31 GMT

See here.

Mon, 06 May 2013 11:56:57 GMT

you can also try like er.

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

load *

FROM

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

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

Next vSheet;

Thu, 13 Jun 2013 10:30:33 GMT

Hi Gysbert,

Could you please attach sample Application .

Thanks and Regards

Satti