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

• Control Flow (Control Flow)
• source (File): The Excel file
• sheet name (String): The name of the sheet in the Excel File. If not specified, the first sheet is read.
• range (String): Where the data should be read from, and optionally where it should be read until. If not specified, the entire sheet is processed. Ex: 'A2' reads from line 2, 'A2:F4' reads from cell A2 until cell F4.

Outputs

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