Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Place your xl file in the same directory/folder where your qlikview application is...
HTH
i did that
but this error still appear
and another error which is
"Out of virtual and/or logical memory"
what is your file extension... biff ???
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
the file extension is xls
go to user preferences>export
chek the on BIFF Exports and increase the export memory limit..
Hope now your problem gets resolved 🙂
HTH
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
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