Excel To Json

Converts an Excel file to JSON

Description

Converts an Excel file to JSON. Each line of the Excel file in Sheet Name sheet will be represented as a JSON object.

Example

(For readability purposes, the Excel file is represented as CSV)

Excel file:

firstname,lastname
john,doe
jane,doe

Resulting JSON:

[
  {"firstname":"john", "lastname":"doe"},
  {"firstname":"jane", "lastname":"doe"}
]

Inputs

• source (File): The Excel file
• sheet name (String): The name of the sheet in the Excel File (defaults to the first one)
• range (String): A specific range within the Excel sheet to read from. If not specified, the entire sheet is processed.
  Ex.: 'A1:F4'

Outputs

• output (List): The resulting JSON
• Error Flow (Error Flow): Error Flow