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

[#2]

We found a solution that fixed this error from server.

1. Remotely Login to Qlik Server Service Account
2. Open IE and add the SharePoint sites to the
   Sites       IE-->Tools-->Security-->Local
   Intranet-->Sites.

I hope this worked for you!

[#3]

Hi, I found a solution that works for me.

I had temporary files in folder,  those files were the problem.

Erase temporary files in folder. You can find them by selecting "show hidden files, folders, and drives" and not selecting "hide protected operating system files" in Tools/Folder Options, sheet View

I hope this helps!

[bobbydave]

I know this is a really old post but I've just had the same issue and I found the issue is simply junk files in the source folder location.  Ensure you have correcting naming conventions in your folder.

I found xlsx files that were called $2016xxxx.xlsx files within my source folder and once I deleted this, boom! All worked.

[Anonymous]

Thanks Rebecca, removed sheet password protection and script moved forward.

[#6]

Hi Elizabeth,

What you have to do is uncheck the Relative Paths when you open the file for loading data for the first time (you can change it later on). It's a work around I've found for this "bug".

Hope it helps, please let me know!

[vishsaggi]

I know this is an old post. I too had the same error. But what i did was, created a dummy qvw file and tried pulling the excel sheet data from a shared location. Like below :

LOAD *

FROM $(vFilepath)xyz.xls

(biff, embedded labels, table is [Report$]) ;

i was getting bad zip error when below script was used:

LOAD *

FROM $(vFilepath)xyz.xls

(ooxml, embedded labels, table is [Report$]) ;

I am not sure why, but I think it is reading as xml before rather than regular standard binary interchange file format (BIFF excel).

IT worked perfctly when above standard biff used.

[#8]

Yes, Exactly. I have removed the Http: and change the forward slash to backward slash. Its working!!!

QlikView cannot recognize the url with http for sharepoint.

[#9]

Hi,

Maybe you rename your excel files and that isn't the way. You have to open your .xls file and save as .xlsx format.

I do that and it work correctly.

[shane_spencer]

This worked for me thanks!

[Anonymous]

All,

I found a workaround for this issue. you can save the excel as .xlsx and then try with below syntax. The issue will get resolved.

LOAD *

FROM $(vFilepath)xyz.xlsx

(ooxml, embedded labels, table is [Report$]) ;

Thanks,

Umashankar