Consuming Excel document stored in Sharepoint

[#1]

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.

[#2]

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

[boorgura]

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.

[boorgura]

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

[#5]

Hi,

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

Then the direct load command does not work.

JOlanda

[#6]

Hi

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?

J

[stevedark]

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

[#8]

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

Jolanda

[stevedark]

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

[Anonymous]

Hello Steve,

Did you get it to finally work?

Antoine