Question, I have a excel file with different sheets?

[#1]

Hi, i have a excel file with different number of sheets I  want to upload to Qlickview , the question is do i have to upload each page alone because I  tried otherwise in vein.

[Anil_Babu_Samineni]

You want upload to qlikview? What does the mean. Does it mean to say you want to pull the data from excel for all different sheets, If so, Does excel has different sheets. Each sheet has same format? Then, no need to use different load rather we can get all sheets at a time by using * in your sheets placed.

[vardhancse]

**Just change the file path

FOR EACH file in FileList('Filepath\*.xlsx');

ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));

If Wildmatch(sheetName, 'sheet1*','sheet2*') Then

Table:

Load *

From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

ENDIF

NEXT i

Drop table tables;

Next file