Is it possible to load a LAN Excel file into a SP 2013 Doc Library


Badge +9

What are the suggestions for on a daily basis loading the latest Excel file from a shared drive (it is not on the SharePoint server) to a document library.  The example would be retrieving a file called contacts.xlsx located on a shared drive into the Doc Library on SharePoint called Contacts.


4 replies

Userlevel 7
Badge +17

I've done this before using a PowerShell script that was scheduled to run daily by Windows Task Scheduler.

Badge +9

Unfortunately Power Shell is not available for us to run sad.png  Thus, I was hoping it might be accomplished within Nintex..

Userlevel 7
Badge +17

I've also used this action ‌ that runs powershell in a workflow. But there isn't an action I find that directly queries a file share via a workflow.

Badge +11

I am facing similar task, where a CVS file gets downloaded from SAP with a lot of information which then is needed to be  updated into the Sharepoint List with relevat data only e.g. Holiday Balance etc.

I been thinking about how to tackle the task :/

Reply