SpreadSheet to JSON

This activity converts a spreadsheet (xlsx file) in to a JSON file. To achieve this, add this activity your canvas and configure it. Before using this activity, it is important to first use the ‘Spreadsheet Reader’ activity that helps you read (or copy) a particular file. The ‘Spreadsheet Reader’ activity returns a workbook object as output. You need to enter this object in the ‘Workbook Object’ field given in the ‘Spreadsheet to JSON’ activity. Once you are done with this, click on ‘Done’ and run the flow. This will convert the specified spreadsheet in to a JSON file.

spreadsheet-to-json

Output:
  • output-arrow developer-tools-128 SpreadSheet to JSON
    • left-triangle workbook object
    • left-triangle json object