topic Re: Load information from different sheets in qlikview automatic in QlikView

Load information from different sheets in qlikview automatic

fkeuroglian — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Load information from different sheets in qlikview automatic

Mon, 29 Dec 2014 12:33:59 GMT

See the links below :

Loading data from all the tabs of an excel

http://community.qlik.com/message/651303#651303

Re: Load information from different sheets in qlikview automatic

francoiscave — Mon, 29 Dec 2014 12:39:53 GMT

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

Re: Load information from different sheets in qlikview automatic

ecolomer — Mon, 29 Dec 2014 12:53:13 GMT

See this example:

for loop =1 to 3

LOAD

FROM

t1.xls

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

NEXT;

Re: Load information from different sheets in qlikview automatic

fkeuroglian — Mon, 29 Dec 2014 12:53:27 GMT

Thank you SwathiRaj WORKS OK!

Fernando