Error: Bad Zip File

[#1]

Hello,

When I load my script, I have a "bad zip file" error. Is there a typical reason for this kind of error? My script seems to work even with the error... but I would like to solve it anyway.

I load three different kinds of files with a loop and I have the error message at the beginning of each loop.

Thank you for your help!

[alexandros17]

Because one of your files is cripted (rar or zip or something else) and cannot be read

[jaimeaguilar]

Hi,

Are you getting this error message?

if yes, then it is happens because you're trying to load a file extension with wrong syntax. For example trying to load a xlsx with the syntax of a xls file will cause this error. Just double check that you're loading your data with the correct syntax,

regads

[#4]

This is the error message I get:

All the files I load are "xlsx" and the syntax for loading them is also "xlsx"... I don't think they are cripted but how can I control that?

[ashfaq_haseeb]

Is your sheet password protected?

Regards

ASHFAQ

[amit_saini]

Hi Anne,

It may be possibility that source sheet is corrupted if not  than in document properties enable generate log file (in general file). While reloading a log file is create which can be helpful to spot the defective excel file. Along with the error description.

Thanks,

AS

[#7]

No it isn't. How do I know if the source sheet is corrupted? I created a log file but it doesn't help me more...

[ashfaq_haseeb]

Can you try by replacing it with another excel file.

or

try by copying content from old xl to new xl.

Regards

ASHFAQ

[sudeepkm]

maybe one of your source files are xls (97 - 2003 format) file but the extension just changed to xlsx. can you please save all your source files as xlsx and try to load.

[#10]

I juste did this, as you suggested, and it still doesn't work... I saved all files as xslx...

Thank you everybody for your help and your answer... I hope we can find the solution!