topic Re: Bad Zip File - error when trying to access Excel file in QlikView

Bad Zip File - error when trying to access Excel file

Anonymous — Wed, 18 Jul 2018 12:58:41 GMT

Hi All,

I wonder if You guys can help with following situation:

I am trying to load data from Excel (xslx) file stored on Office 365 team site. I am using 'Web Files' button and I keep receiving Bad Zip File error. I am sure that link that I have is correct - when I click on it - it's opening the file in Excel online application.

Before Team Site migration to Office 365, this way of loading data was working on my Desktop Qlikview(ver 11).

Now, after migration, I receive the same error for my desktop version (11) and also server version (12).

Thank You in advance.

Paulina

Re: Bad Zip File - error when trying to access Excel file

BalaBhaskar_Qlik — Thu, 19 Jul 2018 10:32:18 GMT

Try with these:

A solution that fixed this error from server.

Remotely Login to Qlik Server Service Account

Open IE and add the SharePoint sites to the

Sites IE-->Tools-->Security-->Local Intranet-->Sites.

Another:

May be temporary files in folder, those files were the problem.

Erase temporary files in folder. You can find them by selecting "show hidden files, folders, and drives" and not selecting "hide protected operating system files" in Tools/Folder Options, sheet View.

OR Load your tables like this:

LOAD *

FROM $(vFilepath)xyz.xls

(biff, embedded labels, table is [Report$]) ; (see for the value biff)

Re: Bad Zip File - error when trying to access Excel file

BalaBhaskar_Qlik — Thu, 19 Jul 2018 10:32:41 GMT

You may check this link:

Office 365 Excel file how to connect in Qlik View