Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Convert Excel to JSON
This bot generates a JSON file from an Excel input file using a Python script
Top Benefits
- Useful to pass JSON object to Web services i.e. REST or SOAP
Tasks
- An Excel file is used to get input data
- Passes the input file path to Python function
- Converts the Excel file to JSON file
- Stores the JSON file into output folder with the same input file name
- Converted file is into .json format
This bot is used for generating JSON files from input Excel files in a folder. The Python script is used for converting Excel data to JSON data. After conversion, the JSON file will be stored in an output folder with a folder name the same as in the Excel file. The folder will contain a sheet with the JSON file.