Hi,
i have to read an Excel-file from a Sharepoint-Site. The Authentication Method is Kerbeos.
Any suggestions ?
Barbara
Question
Reading excel files from Sharepoint
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Currently, the easiest is probably to map the Sharepoint site as a network drive, then read the Excel file from there. Example: https://www.clouddirect.net/knowledge-base/KB0011543/mapping-a-sharepoint-site-as-a-network-drive
Safe is currently working on a SharepointConnector transformer that will allow you to read and write files directly to Sharepoint, but it's still in development.
@barbara @david_r
The new transformer we are working on is the SharepointOnlineConnector which will allow the listing, download, upload, and deletion of files in Sharepoint Online via Microsoft Graph API.
I am adding this to just clarify that the upcoming transformer is targeting Sharepoint Online only for now which might not necessarily fit this particular use case (e.g. no support for Kerberos).
If at all possible we might be looking into leveraging Microsoft Graph endpoints for Sharepoint on-premise solutions to expand the capabilities in the future. But currently, this is not planned.