specific data from excel sheet

[vireshkolagimat]

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]

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

[settu_periasamy]

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]

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]

Hi,

Look into this ,

Loading Excel Data into QlikView

HTH,

Hirish

[vireshkolagimat]

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]

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