Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

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
4 Replies
francoiscave
Partner - Creator III
Partner - Creator III

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
Master II
Master II

See this example:

for loop =1 to 3

LOAD

     A,

     B,

     C

FROM

t1.xls

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

NEXT;

fkeuroglian
Partner - Master
Partner - Master
Author

Thank you SwathiRaj WORKS OK!

Fernando