Excel - Insert JSON Data

Use this robotic process to automatically update an Excel spreadsheet and output the saved XLSX file in the cloud. The robotic process reads in an XLSX file, grabs JSON data from input parameters, updates each row and sheet with the parsed data, and outputs the saved file.

Functionality:

  • Executes Robotic Process from Appian Interface with Smart Service Button Click
  • Robotic Process opens excel file
  • Gets Invoice and Purchase Order JSON arrays from input instructions
  • Loops data
  • Enters data into excel file
  • Saves and outputs updated file

Dependencies:

  • Excel
  • Can be run on Linux, Mac, Windows
Anonymous