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]

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.

[#3]

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.....),

)));

[#4]

Use the following:

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

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

[#5]

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

[#6]

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?

[#7]

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.

[#8]

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"

[#9]

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.

[nagaiank]

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.