topic Re: Load data Excel to Multiple sheets in QlikView

Load data Excel to Multiple sheets

srinu1331 — Tue, 14 Mar 2017 12:07:21 GMT

How to load with data from single excel with multiple sheets with single Load statement

vinieme12 — Tue, 14 Mar 2017 12:12:06 GMT

See this thread

dsharmaqv — Tue, 14 Mar 2017 12:14:32 GMT

hope it helps

FOR each vFile in filelist('$(vSourceLocation)/File.xlsx')

FOR i = 0 to 1

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

Table:
LOAD *

FROM
[$(vFile)]
(ooxml, embedded labels, table is [$(vSheetName)]);

NEXT i

srinu1331 — Tue, 14 Mar 2017 12:38:16 GMT

if u possible explain it

where we declare the file path

dsharmaqv — Tue, 14 Mar 2017 12:42:13 GMT

setting > variable overview

or @ load script like below

let vSourceLocation = '..\01SourceFile\';

rajeshqvd — Thu, 21 Jun 2018 11:28:14 GMT

ODBC CONNECT TO [EXCEL;DBQ=C:\USERS\RAJESHG\DESKTOP\Multiexcelsheet.xlsx];

Let vfile ='C:\give your path\Multiexcelsheet.xlsx';

Exceltable:

SQLTABLES;

DISCONNECT;

for i=0 to NoOfRows('Exceltable')-1

Let vExcelsheets = PurgeChar(Peek('TABLE_NAME',i,'Exceltable'),'$''');

LOAD *

FROM

$(vfile)

(ooxml, embedded labels, table is [$(vExcelsheets)]);

DROP Table Exceltable;