topic Sharepoint 2007 Team site in QlikView

Sharepoint 2007 Team site

Tue, 11 Mar 2014 10:44:56 GMT

Hi,

is it possible lo LOAD an Excel file published on a intranet Sharepoint 2007 Team site?

Many thanks!

Romeo Pavoni

amit_saini — Tue, 11 Mar 2014 11:03:17 GMT

Hi Stefano ,

It is possible. Please follow these steps:

1. Go to your excel sheet on share point and right click for the properties.

2. Then copy the Address(Url) : http:.......(For Example)

3 . Go to your qvw file than go to back-end (ctrl +E) and select web file option and paste the copy url here .

4. This will allow you to read your excel sheet from sharpoint

Tue, 11 Mar 2014 14:19:02 GMT

Hi Amit,

Immediately, under the form "File Wizard : Type" all is blank, and going forward trying to run this generated statement:

LOAD * FROM

(ooxml, embedded labels);

it does the error: "Script error"

any clue?

amit_saini — Wed, 12 Mar 2014 04:14:10 GMT

Are you calling this link from Internet File option under File Wizard ? If no then please call it through the same.

Thanks,