topic Re: File xls error in load in QlikView

File xls error in load

marcello — Fri, 14 Apr 2023 14:45:58 GMT

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

Re: File xls error in load

Ray_Strother — Fri, 14 Apr 2023 17:14:42 GMT

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);

Re: File xls error in load

marcello — Thu, 20 Apr 2023 08:33:23 GMT

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