How to omit rows from an imported Excel document in Qlikview

[#1]

Hello,

I am trying to import an Excel document into Qlikview. This Excel document has thousands of rows and rows 1-8 are solely used for titles. So, I want Qlikview to only look at row 9 and beyond. How can I import only rows x >=9?

I've tried:

Directory;
LOAD B,
C, 
D, 
E, 
G,
Y,
AZ,
BB,
BC,
BH,
BI,
FROM
[Source]
(ooxml, explicit labels, table is [Source])

WHERE RowNo() >= 9;

I've also tried:

WHERE (G >= 9) but all this does is only take values in G that are greater than or equal to 9.

So far, neither of these options is working. Any help is greatly appreciated.

[trdandamudi]

May be as below:

LOAD [Header 9],

    ID,

    Name

FROM

(ooxml, embedded labels, header is 8 lines, table is Sheet1);

[tamilarasu]

As mentioned by Thirumala you can use header size in file wizard to load from row 9.

You can alos use below method. (Note: I have used RecNo() function instead of RowNo())

Directory;

LOAD B,

C, 

D, 

E, 

G,

Y,

AZ,

BB,

BC,

BH,

BI,

FROM

[Source]

(ooxml, explicit labels, table is [Source])

WHERE RecNo() >= 9;