This package includes an action that is used to convert an Excel file into JSON format
Top Benefits
Convert Excel file into Json script
Output format is .json and the user can directly use it in an editor
Easy to use for converting data
Reliable and efficient
Fast conversion
Actions
Read input Excel file path to fetch the file
Choose a string variable to store the output
The output files will be created in the output folder
Message box action is used to print the output in the bot
Excel to JSON Package can be used for all of the actions included in it. This package includes an action that is used to convert an Excel file into a JSON string. In this package, an action uses the .xlsx extension for conversion, and the output will be in the .json format. The user can directly edit this converted JSON data.
See the Package in Action
Setup process
Install
Download the Package and follow the instructions to install it in your AAE Control Room.
Configure
Use the Package in a bot, configure keys and other credentials the Package will need (see the ReadMe for details.)
Run
That's it - now the Package is ready to get going!