Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jasonwills
New Contributor II

Load Certain Excel Cell

Hi All,

I know this is a silly, simple one, but I cannot figure it out.

I have a load statement that is loading data from an excel sheet - however, what I'd like to do is to specify a certain cell to import.

e.g - I only want to import the data from E6 on the Data sheet for example.

Thanks in advance all, I do appreciate it.

Regards

Jason

Tags (1)
1 Solution

Accepted Solutions

Re: Load Certain Excel Cell

Hi Jason,

Try like below,

E19:

LOAD E

FROM

Sourcefile.xlsx (ooxml, no labels, table is Sheet1)  WHERE RecNo() = 6;


Here, "E" is column name as we have mentioned no labels for headers. Recno() specifies the cell address. Let me know.

3 Replies

Re: Load Certain Excel Cell

Hi Jason,

Try like below,

E19:

LOAD E

FROM

Sourcefile.xlsx (ooxml, no labels, table is Sheet1)  WHERE RecNo() = 6;


Here, "E" is column name as we have mentioned no labels for headers. Recno() specifies the cell address. Let me know.

jasonwills
New Contributor II

Re: Load Certain Excel Cell

Perfect, thanks Tamil,

it was getting the RecNo() syntax in there which I was not doing.

Thankyou very much.

Jason

Re: Load Certain Excel Cell

You are welcome.