topic Re: Excel Sheet in QlikView

Excel Sheet

Nagaraju_KCS — Tue, 03 Sep 2013 17:01:14 GMT

Hi All,

i have Excel sheet, i have 4 sheets

CRICKET:

LOAD Name,

Born,

Country,

Tests,

ODIs,

T20s

FROM

(biff, embedded labels, table is [India$]);

i want to load 4 sheets at a time..

Thanks...........

simondachstr — Tue, 03 Sep 2013 17:10:41 GMT

You should find many answers to your questions here:

Wed, 04 Sep 2013 11:18:55 GMT

hi try according to this. hope this helps you

The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements.

LET vStartSheetNumber = 1;

LET vEndSheetNumber = 4;

LET vExcelFileName = 'Data';

// Generate Empty table

Data:

LOAD

'' AS Data.Field1,

'' AS Data.Field2

AutoGenerate(0);

FOR index = vStartSheetNumber TO vEndSheetNumber

Concatenate(Data)

LOAD

FROM [$(vExcelFileName).xlsx]

(ooxml, embedded labels, header is 10 lines, table is [Page $(index)]);