File xls error in load

[marcello]

Hi all,

I cannot load an xls file,

When i try to add it in the script editor it is not recognized (cannot see any cell)

It does no metter what format (xls, xlsx, ...) or headers lines i specify

This happens using QlikView 12.70.201. In a new qlikview installation on a new server, while if i do the same operation on my pc (who has office installed) and qlikview 12.20 with the same file  it works fine.

Any idea ?

Thanks in advance, Marcello

[Ray_Strother]

Hello ,

If you have Qlikview Desktop loaded on the server and got " Load editor" >Data from Files >  Table Files > select the excel files .  

Questions :

1. What Hhappens

2. Does it create the load and From statements?

3. The from statement should look something like this: 

FROM
[C:\Users\Administrator.DOMAIN\Desktop\Sales.xlsx]
(ooxml, embedded labels, table is SalesData);

[marcello]

Hi,

you asked me:

1. What Hhappens

It does not list any data columns or row

2. Does it create the load and From statements?

Yes the load statements is created and looks like this:

FROM
[C:\Users\Administrator.DOMAIN\Desktop\Sales.xlsx]
(biff, embedded labels, table is SalesData);

3. The from statement should look something like this: 

[...]

see the above answer

Regards, Marcello