Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issues with xlsx file

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?

7 Replies
Giuseppe_Novello

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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Not applicable
Author

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

Not applicable
Author

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.

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

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,

jagan
Luminary Alumni
Luminary Alumni

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

If you can share some sample it would be great.

Regards

ASHFAQ