Load data Excel to Multiple sheets

[srinu1331]

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

[vinieme12]

See this thread

QlikView Addict: Looping Through Excel Sheets

[dsharmaqv]

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

NEXT

[srinu1331]

if u possible explain it

where we declare the file path

[dsharmaqv]

setting > variable overview

or @ load script like below

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

[rajeshqvd]

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)]);

NEXT

DROP Table Exceltable;