Bad Zip File Error from reading XLS files

[#1]

Hello!

I'm trying to loop through a folder of almost identical XLS files. by using FROM [Filepath\*.xls]

(similar to what i've done to loop through a folder of .XLSX files)

But, when i execute the script with .XLS files, i get the error "Bad Zip File"

When using Edit Script-- Table Files-- Qlikview is unable to read the XLS file in the "Excel (xls)" format and gives the message "Cannot read BIFF file"

Rather than changing all the .XLS files to .XLSX, I want to find a way for Qlikview to read the . XLS files.

Please let me know any advice you have on this issue!

Thank you!!

-Liz

[sravankumarp]

I too faced the same issue,

Issue is due to corrupted file.
Qlikview was not able to read data from corrupted file, so it was throwing error.

In my case, xls file was generated by system, it might generated corrupted file. I tried to open file but i was not able to open. I confirmed this way.
Kindly check in your case.