topic Re: Issues with xlsx file in QlikView

Issues with xlsx file

Mon, 18 Aug 2014 20:43:54 GMT

I am having an issue where Qlikview is unable to open an xlsx file.

If I try to open it via Qlikview's wizard, I get the following screen:

No matter what I try, the preview does not come up.

Trying to load the file I get the following error:

There seems to be something wrong with the xlsx file itself...opening it in Excel and re-saving it seems to remove this issue and Qlikview is able to save it just fine.

Has anyone had this issue?

Re: Issues with xlsx file

Giuseppe_Novello — Mon, 18 Aug 2014 20:52:44 GMT

Dear Vshulina,

Where's the document located? in you local computer, network drive, etc? Make sure that the user that you are logged in have full rights on the document (READ/WRITE). I can see that you are using a UNC path to reach the shared file that has the document stored. Can you try move it locally and try again?

Gio

Re: Issues with xlsx file

Mon, 18 Aug 2014 21:43:58 GMT

And i would try it with the same xlsx renamed to c:\temp\a.xlsx with in this tempfolder, a test.qvw trying to load the xlsx file

perhaps the name of the path and/or file is too long or has illig characters. Also make sure the tempfolder has sufficient access (for testing purpuse, grant everyone in this folder r/w)

I assume that in excel there are no problems? Anything special in the file? Do new, simple xlsx files also have problems?

Roberto

Re: Issues with xlsx file

Mon, 18 Aug 2014 21:55:57 GMT

Moving the file to a local directory did not work.

Similar files open just fine.

The file in question gets updated daily via a VBA macro from Outlook. The macro takes a file from an email attachment sent every morning and replaces the existing file.

The attachments used to be xls files, however they have been changed to xlsx's. This is when the problem started.

Like I mentioned, opening the file in Excel and simply saving it over itself seems to fix the issue and the Qlikview is able to open it after that.

However this defeats the point of having the entire process automated, so I'm trying to figure out what's wrong with the file that this is happening.

Re: Issues with xlsx file

jaimeaguilar — Mon, 18 Aug 2014 23:04:56 GMT

Hi,

maybe the macro that generates this XSLX is having troubles with the file extension when creating the file, making that the file is like "corrupted" so QlikView doesn't recognize it. So what I think that you may check the subroutine that is used to generate the excel file,

hope this helps,

regards

Re: Issues with xlsx file

Mon, 18 Aug 2014 23:44:36 GMT

Hi,

Maybe XSLX file may have strange characters.

First save the file as a CVS(text) file, then make sure that it has strange characters .

WanKi,

Re: Issues with xlsx file

jagan — Tue, 19 Aug 2014 03:26:25 GMT

Hi,

I think the file is corrupted, that is why Qlikview is not able to read the data, try to fix the macro you are using to update the excel file. It is the issue with Excel, nothing to do in Qlikview.

Regards,

Jagan.

Re: Issues with xlsx file

ashfaq_haseeb — Tue, 19 Aug 2014 05:29:14 GMT

Hi,

If you can share some sample it would be great.

Regards

ASHFAQ