Skip to main content
Question

Reading .xlsx Excel file in Sharepoint 2013 (ssl)


Hi-

I'd like to read the contents of a working Excel file in a 2013 Sharepoint document library - to transform and put elsewhere.

 

I have success doing this using (licensed) FME Desktop/workbench 2016, but cannot automate the task with (demo) FME Server [or as a scheduled desktop task].

 

Is there an SSH limitation with FME between the command-line executable versus the workbench? Is there a proper way to map my Sharepoint library?

Thanks in advance.

~jake

5 replies

mark2atsafe
Safer
Forum|alt.badge.img+44

Hi Jake

How are you reading that with Desktop? As far as I can see we don't yet have the capability to read from a Sharepoint document library. Are you using a HTTP transformer or a reader of some other format to do this? Until I know how it's being done, I'm not sure if I can help with your problem getting it to work on Server.

Regards

Mark


jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • April 11, 2016

The only way I was able to read Excel files from our sharepoint was when using NTLM authentication.


Forum|alt.badge.img
  • July 6, 2016
Hi Jake, Could you share your process for bringing in the excel data from SharePoint? More and more of our users are putting their documents in SP and seeing how you were able to access your would be helpful. Thanks

jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • July 6, 2016
slamon wrote:
Hi Jake, Could you share your process for bringing in the excel data from SharePoint? More and more of our users are putting their documents in SP and seeing how you were able to access your would be helpful. Thanks

I just used a regular excel reader with the source set to the http link of the excel file.

 

(https://x.com/Shared%20Documents/file.xlsx) and the network authentication set to NTLM.

 

 

It works on both desktop and server.

slamon wrote:
Hi Jake, Could you share your process for bringing in the excel data from SharePoint? More and more of our users are putting their documents in SP and seeing how you were able to access your would be helpful. Thanks

 

Can you show/tell us how you were able to read the contents of a working Excel File in a 2013 doc. library? I can only read metadata of the excel folders. This is probably one of the much requested and awaited FME upgrades.

 

Thanks,

 

 

DB

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