topic Re: Zip Error in Qlikview in QlikView

Zip Error in Qlikview

Wed, 27 Jan 2016 14:40:06 GMT

HI Team

when i'm trying to reload the script i'm getting the following error . could any one suggest me what to do???

Re: Zip Error in Qlikview

simospa — Wed, 27 Jan 2016 14:50:29 GMT

Hi,

try to change last line of your script in

...

FROM

ABC classification for PC 2001 - SSoT.xlsx

(biff, embedded labels, header is 1 lines, table is [ABC classification]);

Re: Zip Error in Qlikview

Wed, 27 Jan 2016 15:01:08 GMT

when changed my script

getting this error

Re: Zip Error in Qlikview

p_verkooijen — Wed, 27 Jan 2016 15:06:32 GMT

biff = xls

ooxml = xlsx

Re: Zip Error in Qlikview

Wed, 27 Jan 2016 15:08:28 GMT

HI Paul

Mine is xlsx

when i use ooxml it showing "Zip Error"

could you please suggest me what to do??

Re: Zip Error in Qlikview

p_verkooijen — Wed, 27 Jan 2016 15:14:10 GMT

First try [SSoT_EXCEPTION_LIST_PC 2001.xlsx] because the filename contains a space

Else:

Try to open the file using Table File from the script editor.
What does the wizard make of the file, do you also get a error here ?
Opening the file works with Excel ? Try Save as

Re: Zip Error in Qlikview

settu_periasamy — Wed, 27 Jan 2016 15:39:47 GMT

Check this discussion

Re: Zip Error with SharePoint

Re: Zip Error in Qlikview

Wed, 27 Jan 2016 16:03:34 GMT

Hi Settu

I opened the URL in the Chrome browser its opening with out any error

any more suggestions pls...

Re: Zip Error in Qlikview

petter — Wed, 27 Jan 2016 16:19:00 GMT

XLSX file extension is an OOXML-format file. This file is a zipped directory-structure containing the entire structure of files mostly in an XML-format that is your entire Excel Workbook.

If the integrity of the file is comprimised then it would be natural that the driver gives such an error message.

To test whether this is the case you could make a copy of the file and rename it to test.zip and then you could try to unzip it directly in Windows File Explorer. If it unzips without a problem the XLSX-file shouldn't be corrupted.