Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paulchartier
New Contributor

Failed to open file xlsx

Hi,

I am trying to open a .xlsx file from Qlik Sense Server.

I created a connection to the folder where is located the file, and when I try to select the data, Qlik sends me this error :

image.png

(It is in french)

It means: "Impossible to open the following file : {0}. Check that the file is available, and then reload the script."

I tried to open another .xlsx document located in the same folder, and it worked.

I thought about access rights issues, but it does not seem to be the case as I previously managed to open the file in Qlik Sense, and nothing changed in the server.

If you have any idea of what could be the issue, please share it.

Paul

7 Replies
mwoolf
Honored Contributor II

Re: Failed to open file xlsx

Can you open the .xlsx file manually?

If so, try open and repair to see if the file is corrupt.

paulchartier
New Contributor

Re: Failed to open file xlsx

Yes, I can open it manually.

Sorry, I forgot to mention it.

The file seems to be perfectly valid.

balabhaskarqlik
Honored Contributor

Re: Failed to open file xlsx

May be, if this file is generated by any subroutines, this XSLX is having troubles with the file extension  when created, 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.

It is the issue with Excel, nothing to do in Qlikview.

paulchartier
New Contributor

Re: Failed to open file xlsx

The file was generated manually.

I also think that the issue comes from the excel file.

I think it is weird that Qlik finds the file in its explorer but cannot display the name of the file in the error message. Maybe it is a lead.

imhappiee
New Contributor III

Re: Failed to open file xlsx

Hi,

Try copying the data in that excel to a new excel file and try loading the new excel file, if that loads then it might be issue with the original excel file

Give it a try

Anand

paulchartier
New Contributor

Re: Failed to open file xlsx

Hi Anand,

I did the copy pasting and it worked.

It is a good way to get round the problem.

I still wonder what is the issue with the original file, because it once worked.

I leave the topic opened for that purpose.

Thanks anyway.

imhappiee
New Contributor III

Re: Failed to open file xlsx

Cool,

Sometimes the excel file gets partially saved or corrupted due to some unknown bugs , may be that is casuing the issue in your case.

Thanks

Anand