Parsing an Excel file to get the header size

[#1]

Hello everybody !

I would like to know if QV can parse the line of an Excel file to get the position of some values. Indeed, i'm using QV with BW Reports and often, the header size is not the same but the content of the header is similar (same fiels).

Can we use QlikView to get the position of the "header fields" and say:

LOAD....
FROM BW_Reports (...., header size=$(header_size_calculated_before),....)

?

Thanks a lot !

[achiever_ajay]

Hi Franck.Deny

I am facing simliar problem which you have posted. Did you find any work around.

My problem is that, all the data (Tables) will be in same sheet . I tried with Header size, but its fails to stop as there is no limit of lines. can you help me.?

[achiever_ajay]

HI, i Found the solution for Parsing the QlikView to fetch limited rows of data starting from specific line in the Excel file.

The code is.

First 7 // this will say the no of rows to be fetched
LOAD

....

FROM
abc.xls
(biff, embedded labels, header is 28 lines, table is Sheet1$); // this takes lines starting from 28....

Notes:- If there is any blank rows, Qlikview doesnot count it