Excel Sheet

[qv_testing]

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]

You should find many answers to your questions here:

Import multiple sheets in excel

[#3]

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

NEXT