Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscammers
Partner - Specialist
Partner - Specialist

Consume Spreadsheet from Sharepoint

I have to be missing something and it is probably a very simple question.

I have a spreadsheet stored in sharepoint. I want my script to load data from that sheet. What is the syntax to get the sheet? Do I have to write a macro to download the file locally then consume the data from there?

Thanks

Chris

17 Replies
Not applicable

Hi,

Using UNC paths fails for exampel in 64 bit Windows Server 2003 (and possibly other 64 bit clients)

Why don't you download the fiel from SharePoint ( wich is a glorified WebDAV ) using the open-source cURL client ? Mind the %% escape needed in batch files

rem download

curl --ntlm -u "DOMAIN\USER:PASSWORD" --url "https://workspaces.company.com/site/Shared%%20Documents/file.txt" -o file.txt

-Alex

Not applicable

This is correct, the site must be added as a trusted site while logged in with the account that runs the jobs. This was our sticking point.

erichshiino
Partner - Master
Partner - Master

If it helps anyone, I was able to read the excel file with qlikview using the http address:

Use the web file option

http://servername/sites/thefolder/thesheet.xlsx

Regards,

Erich

qlikviewforum
Creator II
Creator II

Hi All

The particular sharepoint where I am going to fetch the data needs authentication. Could you please let me how that can be done please.

Created the new thread for the same below.

http://community.qlik.com/message/249859#249859

Thanks,

qlikview forum

qlikviewforum
Creator II
Creator II

Hi chriscammers,

I am not able to find "open in Windows explorer" in actions. But I have managed to get the path after exporting to spread sheet. So could you please let me know what is the next step once I get the path?

Thanks,

Qlikview Forum

qlikviewforum
Creator II
Creator II

Hi chriscammers,

I have checked in my server but WebClient is not been installed in the server. May I know what is the next step once the WebClient has been installed? So that I can do the same once the WebClient has been installed.

Thanks,

Qlikview Forum

qlikviewforum
Creator II
Creator II

Hi Chris

We are waiting for your reply. Please help!

Thanks,

qlikviewforum

gainkarthi
Partner - Specialist
Partner - Specialist

All,

Where i can get web client service installation.

Regards,

Karthi