Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

[#1]

Dear Experties,

As per my requirements I am loading couple of Excel files into Qlikview while loading am getting BIFF error, Manually I have changed the format to .xls but still the same  error happening.

Don’t know does any one facing this issue before

[Anil_Babu_Samineni]

Same problem here check

ScriptError: Cannot read BIFF file - Any ideas?

[vishsaggi]

Look here if this may be of any help?

Bad Zip File Error from reading XLS files

[vinieme12]

instead of manually changing the file extension do a "save as" and see if it helps

[#5]

Hi Anil ,

They haven't mentioned any Macro code for this .

[#6]

Hi Vishwa,

This is not a realted ZIP error issue

[#7]

Hi Vineeth,

I tried the same way you suggetsed but no use

[vinieme12]

post the script please

[Anil_Babu_Samineni]

They clearly mentioned over theory.

Try to share Excel, So that we can found the issue to solve and please reply to vinieme12 (Reg - Script)

[vinieme12]

Are you trying to do a "save as" on the file that you manually renamed?

do a "save as" of the original .xlsx, it should work