Skip to main content

Insert Row

Inserts a row into an excel file.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If ContinueOnError property is true, no error is caught when the project is executed even if Catch node is used.

Input​

  • Excel File Descriptor - The opened excel file descriptor id obtained from Open Excel Node. This ID is generated by the Open Excel or the Create Excel node.
  • Row Number - The row number after which data has to be inserted.
  • Row Data - The data to be inserted in json format. E.g. {"A": "value1", "B": "value2", "C": "value3"}

Options​

  • Target - Select where to insert the row:
    • Active Row - Inserts the row into the current active row.
    • Specific Row - Inserts the row at a position specified by the row number.
  • Header - If true, the row data json keys will be acted as header names