topic Re: Bad Zip File Error from reading XLS files in QlikView

Bad Zip File Error from reading XLS files

Mon, 25 Mar 2013 21:30:07 GMT

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

Re: Bad Zip File Error from reading XLS files

Mon, 25 Mar 2013 21:37:05 GMT

Make sure your load looks like this:

LOAD Test
FROM

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

and not like this:

LOAD Test
FROM

(ooxml, embedded labels);

That will cause a Bad Zip File error.

Re: Bad Zip File Error from reading XLS files

Mon, 25 Mar 2013 21:43:49 GMT

Thanks for the quick response!

If each file only has 1 sheet in it, and each sheet name for each file is named differently,

can i just upload it using * ?

LOAD Test

FROM

(oozml,embedded labels, table is

, filters (

Remove (etc....),

ColXtr( etc....),

Replace (etc.....),

)));

Re: Bad Zip File Error from reading XLS files

Mon, 25 Mar 2013 21:52:14 GMT

Use the following:

LOAD Test
FROM
[YourFolderLocation\*.xls]
(biff, embedded labels);

Now you shouldn't have a problem with the sheet names.

Re: Bad Zip File Error from reading XLS files

Wed, 27 Mar 2013 20:38:31 GMT

Thanks for your help,

But, when I use that format I get an error that says " Cannot read BIFF file"

Any more suggestions?

Thank you!!

-Liz

Re: Bad Zip File Error from reading XLS files

Wed, 27 Mar 2013 21:11:28 GMT

Hmm. Other than making sure that they are all true XLS files and that none of them are password protected, I am kind of out of ideas. What about you, Gysbert?

Re: Bad Zip File Error from reading XLS files

Fri, 21 Nov 2014 02:50:34 GMT

the url should not be like 'http://servername/foldername/filename'

and it should be like '\\servername\foldername\filename.extension'.

Qlikview cannot recognize the url with http for sharepoint.

Re: Bad Zip File Error from reading XLS files

Fri, 12 Jun 2015 11:36:44 GMT

I am getting the same error on one of my dashboards as well. Everything was working fine for a couple of months and all of a sudden I am getting a "Zip Error"

Re: Bad Zip File Error from reading XLS files

Wed, 22 Jul 2015 18:12:32 GMT

Did anyone find a solution for this? I was able to run on desktop without any problems but from QV server, I am getting 'Zip Error' message.

Re: Bad Zip File Error from reading XLS files

nagaiank — Tue, 18 Aug 2015 08:24:24 GMT

I am also interested to know the solution. I am able to load data from Excel files in the SharePoint server from my desktop without any error. The same script, when run from a Qlikview server, results in the Bad Zip File error. Thank you in advance for your help.

Re: Bad Zip File Error from reading XLS files

Fri, 04 Sep 2015 13:31:14 GMT

We found a solution that fixed this error from server.

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

I hope this worked for you!

Re: Bad Zip File Error from reading XLS files

Mon, 19 Oct 2015 14:09:53 GMT

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!

Re: Bad Zip File Error from reading XLS files

bobbydave — Wed, 25 May 2016 10:34:45 GMT

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.

Re: Bad Zip File Error from reading XLS files

Anonymous — Fri, 15 Jul 2016 13:30:52 GMT

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

Re: Bad Zip File Error from reading XLS files

Thu, 01 Sep 2016 21:28:59 GMT

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!

Re: Bad Zip File Error from reading XLS files

vishsaggi — Mon, 12 Sep 2016 21:55:45 GMT

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.

Re: Bad Zip File Error from reading XLS files

Mon, 10 Apr 2017 10:39:42 GMT

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.

Re: Bad Zip File Error from reading XLS files

Thu, 18 May 2017 16:27:55 GMT

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.

Re: Bad Zip File Error from reading XLS files

shane_spencer — Fri, 11 Aug 2017 08:40:00 GMT

This worked for me thanks!

Re: Bad Zip File Error from reading XLS files

Anonymous — Wed, 18 Oct 2017 08:43:53 GMT

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