Skip to main content
Question

Is it possible to read an xls table stored in SharePoint into FME somehow?


mb_fdfa
Participant
Forum|alt.badge.img+7

We have Sharepoint 2013 Enterprise and numerous excel tables I would like to access are stored there. I've tried and failed to manage to access any. I tried using an xls Reader and a SharePoint Reader. Is the SharePoint List Reader even meant for this? Or is the HTTP Caller the way to go?

 

Is there any better documentation with real examples of what is required for the various SharePoint parameters (site, authentication).

I am using FME 2017.1. Any insight would be appreciated.

3 replies

courtney_m
Contributor
Forum|alt.badge.img+12
  • Contributor
  • August 9, 2017

Have you looked at the comments for this idea? It might be helpful.

 

https://knowledge.safe.com/idea/23503/sharepoint-file-uploader.html

-Courtney


Forum|alt.badge.img
  • August 9, 2017

I have been able to read excel sheets straight from Sharepoint. Use Excel Reader --> Give the actual Path of the document in there (not from address bar) . enable Network Authentication --> Give Authentication type as NTLM. Provide your username and password. It should work @mb_fdfa


nmalazdrewicz
Participant
Forum|alt.badge.img
vikram wrote:

I have been able to read excel sheets straight from Sharepoint. Use Excel Reader --> Give the actual Path of the document in there (not from address bar) . enable Network Authentication --> Give Authentication type as NTLM. Provide your username and password. It should work @mb_fdfa

Hey @vikram,

 

Are you able to provide some more guidance on this? Is this using an Excel Reader, or FeatureReader? In using the FeatureReader, I can't seem to get it to read the Excel file stored in Sharepoint.


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