topic Excel 2007 File on FTP in QlikView

Excel 2007 File on FTP

Thu, 19 Nov 2009 11:46:47 GMT

Hi All,

I have been using Text file / CSV File / XLS file on the FTP Location as a data source for my Qlikview applications. Recently i am getting XLSX Files as the data source. QlikView is not able to identify them as ooxml format by default. Even if i change the code manually to read from the FTP File, QV gives a error as SCRIPT ERROR and does not give any information regarding the same.

If any of you have a solution, please do share with me.

Regards,

Sriram N

Excel 2007 File on FTP

jacekvsp — Thu, 26 Aug 2010 22:55:28 GMT

I have the same problem. Any ideas?

Excel 2007 File on FTP

parpatra — Thu, 03 Mar 2011 19:21:59 GMT

Has anyone found a solution to this? The xlsx files does show anything while reading from FTP location.

Excel 2007 File on FTP

Fri, 11 Mar 2011 13:03:12 GMT

You have problems only with xlsx files or with other files too?

eg. txt or csv reading is OK?

Excel 2007 File on FTP

Wed, 06 Jul 2011 12:36:30 GMT

Seeing the same thing with xlsx files only. csv and xls works fine.

Testing on QV 9 SR3 and QV10 SR1. Problem is the same in both. ftp sees file, but doesn't do preview and can't load data.

strange...

Re: Excel 2007 File on FTP

Wed, 11 Jun 2014 09:25:17 GMT

The .docx and .xmlx are actually ZIP files with loads of XML and other files inside.

Something (maybe your server) detects that the files are ZIPs and marks them as such (using Content-Type header), what makes your browser interpret them as ZIP, despite them not having the .zip extension.