Excel - Insert JSON Data

Please note: This RPA Utility has been archived because the functionality is now available via out-of-the-box Appian RPA actions

Overview

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.

Key Features & Functionality

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