load from multiple sheets in excel file

[#1]

HI All,

i have excel file with 21 sheets  in it

i tried to load them using  this script

FOR Each vSheet in 'Sheet1','Sheet2','Sheet3','Sheet4','Sheet5','Sheet6','Sheet7','Sheet8','Sheet9','Sheet10','Sheet11','Sheet12','Sheet13','Sheet14','Sheet15','Sheet16','Sheet17','Sheet18','Sheet19','Sheet20','Sheet21'

Format:

LOAD Space,

          Title,

          Report_Metrics,

          No,

          Metrics_Segment

From [IndustryMetrics\Format.xls](biff,embedded labels,table is $(vSheet));

next;

but this meesage appear

"Can't read from biff file"

So,What's the problem??

Thanks in Advance

[sushil353]

Place your xl file in the same directory/folder where your qlikview application is...

HTH

[#3]

i did that

but this error still appear

and another error which is

"Out of virtual and/or logical memory"

[sushil353]

what is your file extension... biff ???

[#5]

Hi Mona,

Can you attach a fragment of your Excel file.

Meanwhile, try the following code.

FOR each i = 1 to 21
Format:
LOAD Space,
Title,
Report_Metrics, 
No,
Metrics_Segment
From IndustryMetrics\Format.xls (biff,embedded labels,table is Sheet$(i));
next;

Hope this helps.

Rgrds,

Abhinava

[#6]

the file extension is xls

[sushil353]

go to user preferences>export

chek the on BIFF Exports and increase the export memory limit..

Hope now your problem gets resolved 🙂

HTH

[its_anandrjs]

Hi,

You want to load data from 1 or more excel so use this

Load

From [IndustryMetrics\*.xls](biff,embedded labels,table is Sheet1));

*.xls

I want to know in all 21 sheets data are in Sheet1 or into other sheets

HTH

Rgds

Anand

[sushil353]

[#10]

the error of "Out of virtual and/or logical memory" still occure

after i check on (on biff export) and also increased the export memory limit