Skip to main content
edgardoy0001
March 26, 2021
Solved

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

  • March 26, 2021
  • 2 replies
  • 0 views

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!

    Best answer by mikes0011

    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.

    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
    April 12, 2021

    Hadoukeen!