Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Load information from different sheets in qlikview automatic

Hi expert, i would like to know if there are any way to load information in qlikview from excel that contain several sheet, do it automaticaly not load each sheet in the script

i attached and example from excel with 3 different sheets and a qvw that load each sheet from one on a time.

thank you a lot

Fernando

1 Solution

Accepted Solutions
Not applicable

Re: Load information from different sheets in qlikview automatic

4 Replies
Not applicable

Re: Load information from different sheets in qlikview automatic

Partner
Partner

Re: Load information from different sheets in qlikview automatic

Hi Fernando,

See the link below:

Loading data from all the tabs of an excel

Solution by Anand Chouchan:

For Each vFile in FileList('MulitpleDataExcel.xlsx')
ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)];
Sheets:
SQLTABLES;
DISCONNECT;
For i = 0 To NoOfRows('Sheets')-1
Let vSheet = left(Peek('TABLE_NAME', i, 'Sheets'), len(Peek('TABLE_NAME', i, 'Sheets'))-1);
LOAD '$(vSheet)' as [Tab Name], *
From [$(vFile)]
(
ooxml, embedded labels, table is $(vSheet));
Next;
Next;

Best Regards,

François

ecolomer
Honored Contributor II

Re: Load information from different sheets in qlikview automatic

See this example:

for loop =1 to 3

LOAD

     A,

     B,

     C

FROM

t1.xls

(biff, embedded labels, Table is [Sheet$(loop)$]);

NEXT;

Partner
Partner

Re: Load information from different sheets in qlikview automatic

Thank you SwathiRaj WORKS OK!

Fernando