Skip to main content
Question

Reading excel files from Sharepoint


Forum|alt.badge.img

Hi,

i have to read an Excel-file from a Sharepoint-Site. The Authentication Method is Kerbeos.

 

Any suggestions ?

Barbara

2 replies

david_r
Evangelist
  • June 23, 2020

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.


Forum|alt.badge.img

@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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings