Skip to content
Databraid Docs

Excel to JSON Node

This node converts Excel data to JSON format.

Input

  • excel (blob): The Excel file to be converted.

Output

  • json (object): The converted JSON data.

Properties

  • Sheet Name (text): The name of the sheet in the Excel file to be converted. If left empty, the first sheet will be used.
  • Header Row (number): The row number to be used as the header row for the JSON data. Default is 1.

Usage

  1. Connect a node that provides an Excel file (blob) to the “excel” input of the Excel to JSON node.
  2. Optionally, specify the sheet name in the “Sheet Name” property to convert a specific sheet. If left empty, the first sheet will be used.
  3. Adjust the “Header Row” property to specify the row number to be used as the header row for the JSON data.
  4. The converted JSON data will be available at the “json” output of the node.

>Error Handling

  • If no Excel data is provided, an error message will be set at the “json” output indicating that no data was provided.
  • If the specified sheet name is not found in the Excel file, an error message will be set at the “json” output indicating that the sheet was not found.
  • If the Excel data is invalid or cannot be parsed correctly, an error message will be set at the “json” output indicating an invalid Excel data error.