topic Re: loading xls vs xlsx files in QlikView

loading xls vs xlsx files

Mon, 24 Nov 2014 06:27:39 GMT

Hi,

I am facing an issue while loading xlsx files, I get an error saying "Cannot read from BIFF file".

However, when I save it as xls, it works fine.

So, I tried writing a macro which opens the excel files and replaces xlsx with xls. This did as it was supposed to do, however did not solve the issue as I still get the same error. Also, I will have to deploy the app on a server which will have it's own issues of running a macro.

I have been wondering about the relevance of this approach, as in the coming years, xls files might become irrelevant and outdated and as such saving files as a older file format shouldn't be the fix.

I wanted to know, if there are any alternative ways to handle this and views on the above approach.

Thanks

Re: loading xls vs xlsx files

anbu1984 — Mon, 24 Nov 2014 06:46:14 GMT

ScriptError: Cannot read BIFF file - Any ideas?

Re: loading xls vs xlsx files

Mon, 24 Nov 2014 10:12:05 GMT

hi anbu,

I had gone through that post. That's why I wanted to know if is a good practice, shouldn't there be better ways to handle this?

Also, I am not comfortable with VBA, so my code doesn't work as expected.

Re: loading xls vs xlsx files

Thu, 27 Nov 2014 09:03:23 GMT

loading xls vs xlsx files