topic Re: How to load a excel web file into qlikview? in QlikView

How to load a excel web file into qlikview?

Jesh19 — Wed, 01 Mar 2017 14:20:08 GMT

Hi everyone,

I had a requirement where i need to use excel web file as my source which is in sharepoint site.

I have gone through many study cases on how to load from sharepoint lists.

But I want my data to be loaded from excel web file.

When I tried to import data using xslx, i am getting bad zip file error.

None of the methods is working out.

I would be thankful if someone helps me in this regards.

Thanks in advance.

Regards,

Jeshwanth B

Re: How to load a excel web file into qlikview?

adamdavi3s — Wed, 01 Mar 2017 14:29:07 GMT

Have you tried just .xls?

sorry if that's a dumb question

also check the load syntax:

Bad Zip File Error from reading XLS files

Re: How to load a excel web file into qlikview?

Jesh19 — Wed, 01 Mar 2017 14:42:53 GMT

Hi Adam,

I have tried it(.xls), but of no use.

The link you have given is reading the excel file from our local machine. But my excel is in sharepoint.

Re: How to load a excel web file into qlikview?

adamdavi3s — Wed, 01 Mar 2017 14:59:18 GMT

Hi,

Sorry yes I know that relates to desktop but AFAIK the same rules apply to loading from sharepoint?

i.e. you still need the declaration for biff or ooxml depending on the filetype

Re: How to load a excel web file into qlikview?

Jesh19 — Wed, 01 Mar 2017 17:49:44 GMT

Hi Adam,

How can i know the declaration whether it is of biff or ooxml type when by default it is showing me the error.

It's not letting me import the file.

Re: How to load a excel web file into qlikview?

Peter_Cammaert — Wed, 01 Mar 2017 19:45:59 GMT

Can you open the Excel file from the SharePoint link in er... Excel? If you cannot, then you have either a SharePoint permissions problem, or the file is mimicking an biff/ooxml file but in reality it is something else...

Re: How to load a excel web file into qlikview?

Jesh19 — Thu, 02 Mar 2017 11:45:53 GMT

Hi Peter,

I am able to open the file in excel. But while i am trying to read it into qlikview, it's getting error.