Load specific Excel Cells

[#1]

Hello Guys,

is it possible to load not a whole excel file, but specific cells out of the excel file?

For example, if i only want QlikView to load Cells from B2 to B5.

Anyone who has an idea?

Thanks in advance!

[#2]

Hi,

In the load statement of script part, you can remove the unwanted fields and reload the application.

Regards,

Anitha

[#3]

Thanks for the fast reply.

Is there a possibility to load the cells within the first load, and without a reload of the qlikview file?

These specific Excel File i want to load is just one part of a big script and unfortunately it is not possible to run a partially reload.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Assuming you need to reload the file either completely or partially, you can use a piece of script like the following:

B2ToBB9:
LOAD B, 
FROM
testDataRowsCols.xlsx
(ooxml, no labels, table is Sheet1)
WHERE RecNo() > 1 AND RecNo() < 10;

"B" is the name QlikView uses when there is no label specified or embedded (see the "no labels" tag in the loading parameters of the excel file). Using the function RecNo() you can tell QlikView which rows to load from that excel file, in this case, from row #2 to row #9.

Hope that helps.

Miguel

[#5]

It works. Thanks 🙂

[Anonymous]

i Miguel this is a very old post i see but when i tried this script it doesn`t work for me i am on QV 11

[Anonymous]

Hi Farai,

Try:

Load excel file data normally first and modify script accordingly.

Let me know any issues

regards

Neetha

[Anonymous]

Hi Thanx let me send u sample data of the spreadsheet

[robert_mika]

Please see attached

Script:

Directory;

LOAD Month

FROM

moving.xlsx

(ooxml, embedded labels, table is Sheet1)

WHERE RecNo() > 1 AND RecNo() < 5; 

[Anonymous]

Please look at attached Sample Data