Help

[qv_testing]

Hi Comunity,

can anybody help me.

.I have source Excel file in that 3 sheets, in future i am adding some new sheets

i want to load all sheets

Thanks in Advance

[m_woolf]

Try: http://community.qlik.com/message/15196#15196

[qv_testing]

Hi Michal,

for each vSheet in 'Jan$', 'Feb$','Oct$'

MyTableName:

Load ........From (biff,embedded labels,table is $(vSheet));

next;

If i have up to 10 sheets it's fine for me..

but i don't know how many sheets in my Excel  file

[m_woolf]

Have a look at this:

QlikView Addict: Looping Through Excel Sheets

[qv_testing]

Hi Michal,

ODBC CONNECT TO [Excel Files;DBQ=D:\Players.xlsx];

XlsTables:

SQLTables;

//DISCONNECT;

LET vRows = NoOfRows('XlsTables');

FOR i = 0 TO $(vRows)-1

    LET vSheetName = subfield(peek('TABLE_NAME', i,'XlsTables'),'$',1);

Players:

LOAD Name,

     Born,

     Country,

     Tests,

     ODIs,

     T20s

FROM

D:\Players.xlsx

(ooxml, embedded labels, table is $(vSheetName));

NEXT i

DROP TABLE XlsTables;

[m_woolf]

I believe the script is for .xlsx files.

If you read the entire web page, it mentions below the script that you need to modify the Connect and Load statements for .xls files.

[qv_testing]

Thank you so much it's perfectly alright