topic Question, I have a excel file with different sheets? in QlikView

Question, I have a excel file with different sheets?

Wed, 28 Jun 2017 21:12:54 GMT

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.

Re: Question, I have a excel file with different sheets?

Anil_Babu_Samineni — Thu, 29 Jun 2017 03:27:29 GMT

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.

Re: Question, I have a excel file with different sheets?

vardhancse — Thu, 29 Jun 2017 03:30:07 GMT

**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