Skip to main content
edgardoy0001
New Participant
March 26, 2021
Solved

Reading an excel file in Sharepoint or local directory and inserting its data in the database.

Hi, All! Is it possible to read an excel file on a specific local directory or Sharepoint? Is there any custom code or tool/plugins that can be used? For example, we have a file in Sharepoint and we want Appian to read that file and insert its data in the database.  Have a nice day!

    mikes0011
    mikes0011Answer
    Brainy
    March 26, 2021

    One way or the other I believe you'd need to move the file into Appian's internal filesystem before reading it, after which you could just use the functionality found in the Excel Tools plug-in.

    The Expression Guru

    2 replies

    mikes0011
    mikes0011Answer
    Brainy
    March 26, 2021

    One way or the other I believe you'd need to move the file into Appian's internal filesystem before reading it, after which you could just use the functionality found in the Excel Tools plug-in.

    The Expression Guru
    Known Participant
    April 12, 2021

    Hadoukeen!