Robotic Process Automation

Expand all | Collapse all

Process Excel file which is stored in Sharepoint

  • 1.  Process Excel file which is stored in Sharepoint

    Posted Wed January 20, 2021 08:00 AM
    Hi

    I need to process (read and update) an Excel file which is stored in a Sharepoint environment.
    If I am correct, the current commands to manipulate Excel (like excelGetTable) are for local documents?
    I would rather not use a browser to connect to the Sharepoint-site and manipulate the document from within that browser.
    Any ideas how to get started on this one? Perhaps using a database connection to Sharepoint?

    Thanks in advance.

    ------------------------------
    nordine vandezande
    ------------------------------


  • 2.  RE: Process Excel file which is stored in Sharepoint

    Posted Thu January 21, 2021 07:19 AM
    Hi Nordine, 

    Would it be possible for you to copy the file from sharepoint to a local temp directory, work on that, and then copy it back to sharepoint?

    ------------------------------
    NIGEL CROWTHER
    ------------------------------



  • 3.  RE: Process Excel file which is stored in Sharepoint

    Posted Fri January 22, 2021 03:00 AM
    Hi Nigel 

    thanks for your reply.
    Working on a file copy was actually my backup plan but there are some risk with overwriting data when the original file has changed while processing the copied file. And besides that, I would still need to interact with Sharepoint through a browser: there is a lot of dynamic HTML so it hard to find suitable selectors.


    ------------------------------
    nordine vandezande
    ------------------------------