
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bad Zip File Error from reading XLS files
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
- Tags:
- new_to_qlikview
- « Previous Replies
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make sure your load looks like this:
LOAD Test
FROM
(biff, embedded labels, table is [Sheet1$]);
and not like this:
LOAD Test
FROM
That will cause a Bad Zip File error.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Remove (etc....),
ColXtr( etc....),
Replace (etc.....),
)));

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the following:
LOAD Test
FROM
[YourFolderLocation\*.xls]
(biff, embedded labels);
Now you shouldn't have a problem with the sheet names.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous Replies
- Next Replies »