topic Consuming Excel document stored in Sharepoint in QlikView

Consuming Excel document stored in Sharepoint

Thu, 11 Mar 2010 19:06:57 GMT

Is there a way for the load script to read data from an excel file stored in Sharepoint? Excel files in sharepoint is stored in the sql server as blobs and thus are not easily accessible through unc path. I have tried the http path but that didn't work. I saw a web files button but have not found much documentation on how to use it (it also refers to ftp instead).

Any suggestion would be much appreciated.

Consuming Excel document stored in Sharepoint

Mon, 14 Jun 2010 19:02:57 GMT

any luck with this question? We have the same need...

Consuming Excel document stored in Sharepoint

boorgura — Mon, 14 Jun 2010 19:07:42 GMT

I do read excel files from sharepoint using the http path and i do not have any issues doing so.

Syntax:

LOAD field1,

field2,

field3

FROM "http://websiteaddress/root/folder/File%20Name.xls" (biff, embedded labels, table is [SheetName$]);

Let me know if it works.

Consuming Excel document stored in Sharepoint

boorgura — Mon, 14 Jun 2010 19:08:32 GMT

FYI - you can copy over the path from the properties of that file on that sharepoint.

Consuming Excel document stored in Sharepoint

Wed, 25 Aug 2010 08:56:32 GMT

Hi,

If the sharepoint environment is https, how can one solve that?

Then the direct load command does not work.

JOlanda

Consuming Excel document stored in Sharepoint

Wed, 25 Aug 2010 13:04:05 GMT

Problem does not appear to be the https, but this extraction does not seem to work with excel 2007. (xslx)

Has anybody tried it yet iwth excel 2007?

Consuming Excel document stored in Sharepoint

stevedark — Mon, 07 Mar 2011 17:26:23 GMT

Hi there,

I have also got this working fine with a .xls file, but the same configuration does not seem to work with .xlsx.

Did you find a solution?

I am using QV9 SR4.

Regards,
Steve

Consuming Excel document stored in Sharepoint

Mon, 07 Mar 2011 19:45:21 GMT

Unfortunately not. We are using qlikview 10 now, but no change there either.

Jolanda

Consuming Excel document stored in Sharepoint

stevedark — Thu, 10 Mar 2011 11:02:36 GMT

Hi Jolanda,

Thanks for the update. I am going to take a look at opening the document from the UNC path in SharePoint (eg. \\sharepoint\site\documents\ rather than http://sharepoint/site/documents/), but am now running into a limitation with SharePoint where accessing a document repository as a folder doesn't work on a 64 bit server.

Hoping that the 32 bit load mode on QV 10 will address this - but I have to get the client to upgrade first. Watch this space.

Regards,
Steve

Re: Consuming Excel document stored in Sharepoint

Anonymous — Thu, 04 Sep 2014 07:36:40 GMT

Hello Steve,

Did you get it to finally work?

Antoine