Zip Error in Qlikview

[#1]

HI Team

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

[simospa]

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]);

S.

[#3]

when changed my script

getting this error

[p_verkooijen]

biff = xls

ooxml = xlsx

[#5]

HI Paul

Mine is xlsx

when i use ooxml it showing "Zip Error"

could you please suggest me what to do??

[p_verkooijen]

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

[settu_periasamy]

Check this discussion

Re: Zip Error with SharePoint

[#8]

Hi Settu

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

any more suggestions pls...

[petter]

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.