topic Re: Cannot open xlsx file format in App Development

Cannot open xlsx file format

clarisa — Wed, 24 May 2023 13:23:37 GMT

Hello everyone,

I am trying to open a .xlsx file and I get the following error:

After investigating further, I noticed that the file "xl/_rels/workbook.xml.rels" is present within the extracted contents of the file.

Interestingly, when I manually perform a "save as" operation on the file, I am able to open it without any issues. However, this is not a sustainable solution for me as the file is downloaded and updated on a daily basis.

If any of you have encountered a similar problem or have insights that could potentially help me, I would greatly appreciate your assistance. Any advice, suggestions, or workarounds you can provide would be incredibly valuable to me.

Thanks in advance 🙂

Re: Cannot open xlsx file format

marcus_sommer — Wed, 24 May 2023 14:58:09 GMT

The file-format of the file isn't close enough to specified standards of ooxml - at least within a more strict sense. This is probably caused from the source which isn't a desktop Excel else another tool with some variance by features or the age of the used libraries.

So the best would be to adjust the Export tool/routines or switching to another output-format, for example in csv. If this isn't possible there would be probably only workarounds like the mentioned "save as" - whereby such tasks could be automated by any macros.

Re: Cannot open xlsx file format

clarisa — Thu, 25 May 2023 06:49:24 GMT

Thanks for you help, Marcus! As you pointed out, the file is not being generated in a desktop Excel application.
I think the message from Qlik was not clear enough, so I appreciate your clarification.