topic Re: specific data from excel sheet in QlikView

specific data from excel sheet

vireshkolagimat — Wed, 06 Apr 2016 13:49:58 GMT

Hi Team,

if QlikView has the capability to reference a specific cell range in an Excel file? For example, could it look specifically at something like A3:F20?

Regards,

Viresh

sunny_talwar — Wed, 06 Apr 2016 15:20:06 GMT

Yes you can play around with the settings of what you need to bring in. Do you have a sample?

settu_periasamy — Thu, 07 Apr 2016 02:38:58 GMT

Hi,

You can use 'First' statement before Load Statement. for e.g if your data some thing like below screen shot..

First 18
LOAD A,
      B,
      C,
      D,
      E,
      F
FROM
Book1.xlsx
(ooxml, no labels, header is 2 lines, table is Sheet1);

tamilarasu — Thu, 07 Apr 2016 03:48:52 GMT

Hi,

You can also use RecNo() function to load specific cells. Below script loads data from range A3:F20.

LOAD A,
     B,
     C,
     D,
     E,
     F
FROM
[EmpOff.xlsx]
(ooxml, no labels, table is Employee) Where RecNo()>2 and RecNo()<21;

HirisH_V7 — Thu, 07 Apr 2016 04:04:32 GMT

Hi,

Look into this ,

HTH,

Hirish

vireshkolagimat — Wed, 13 Apr 2016 04:10:10 GMT

Hi please find the below sample.I want to bring the data as is into QlikView and also the range is not fixed.

Thanks

Viresh

Joaquin_Lazaro — Wed, 13 Apr 2016 09:57:26 GMT

Hello:

In the script window press button TableFiles, select your excel file, press next twice then press Enable Transformation Step

Hope it helps you

Joaquín