Hi,
Is it possible to download/read an excel file from SharePoint?
I can read the contents of the site using the SharePoint list reader, but unsure if I can then actually read a spreadsheet stored there?
Thanks,
Sam
Solved
Is it possible to download/read an excel file from Sharepoint?
+3- Contributor
Best answer by sipsysigh
Hi @sam_tw,
Is the version of SharePoint, where the Excel file is located, Online or Server? If Online, then as far as I know, you can't connect using the Excel Reader as it requires SAML Authentication. If however it's SharePoint Server, then as @jdh has said, you should be okay. Select File From Web and Specify the URL to the SharePoint Site:
You should then have the option, as @jdh says, to Use Network Authentication and select NTLM as the Authentication Method.
Hope this helps.
Simon
+28- Contributor
I have successfully pointed an excel reader to a sharepoint file. It depends on the permissions.
+3- Contributor
jdh wrote:
I have successfully pointed an excel reader to a sharepoint file. It depends on the permissions.
I am the file owner so have permission to edit it. Does it require more than that?
+28- Contributor
sam_tw wrote:
I am the file owner so have permission to edit it. Does it require more than that?
On the excel reader, there should be a parameter called network authentication. In my setup, I used NTLM authentication.
+7- Contributor
- Best Answer
Hi @sam_tw,
Is the version of SharePoint, where the Excel file is located, Online or Server? If Online, then as far as I know, you can't connect using the Excel Reader as it requires SAML Authentication. If however it's SharePoint Server, then as @jdh has said, you should be okay. Select File From Web and Specify the URL to the SharePoint Site:
You should then have the option, as @jdh says, to Use Network Authentication and select NTLM as the Authentication Method.
Hope this helps.
Simon
+3- Contributor
sipsysigh wrote:
Hi @sam_tw,
Is the version of SharePoint, where the Excel file is located, Online or Server? If Online, then as far as I know, you can't connect using the Excel Reader as it requires SAML Authentication. If however it's SharePoint Server, then as @jdh has said, you should be okay. Select File From Web and Specify the URL to the SharePoint Site:
You should then have the option, as @jdh says, to Use Network Authentication and select NTLM as the Authentication Method.
Hope this helps.
Simon
Ah it is the online version of Sharepoint which explains why it isn't working, but the Sharepoint list reader using SAML does. Thanks
sipsysigh wrote:
Hi @sam_tw,
Is the version of SharePoint, where the Excel file is located, Online or Server? If Online, then as far as I know, you can't connect using the Excel Reader as it requires SAML Authentication. If however it's SharePoint Server, then as @jdh has said, you should be okay. Select File From Web and Specify the URL to the SharePoint Site:
You should then have the option, as @jdh says, to Use Network Authentication and select NTLM as the Authentication Method.
Hope this helps.
Simon
When I go "Select File from Web" -> "Specify URL": the link required seems to start with http: but my link start with https; and then if I put my link (the one with https) there, the transformer doesn't read anything. I did try to change to http but it doesn't work either.
what does this indicate?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.