topic Re: Help in QlikView

Help

Nagaraju_KCS — Thu, 05 Sep 2013 17:58:27 GMT

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

Re: Help

m_woolf — Thu, 05 Sep 2013 18:09:22 GMT

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

Re: Help

Nagaraju_KCS — Thu, 05 Sep 2013 18:21:06 GMT

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

Re: Help

m_woolf — Thu, 05 Sep 2013 19:01:36 GMT

Have a look at this:

QlikView Addict: Looping Through Excel Sheets

Re: Help

Nagaraju_KCS — Thu, 05 Sep 2013 19:18:47 GMT

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;

Re: Help

m_woolf — Thu, 05 Sep 2013 19:22:07 GMT

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.

Re: Help

Nagaraju_KCS — Thu, 05 Sep 2013 19:48:27 GMT

Thank you so much it's perfectly alright