Skip to main content

Set Range

Sets a range of cells in excel with a data table input.

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 descriptor for the excel file containing the desired range. This ID is generated by the Open Excel or the Create Excel node.
  • Start Cell - The cell to start the range from.
  • Table - The data table data containing the range.

Options​

  • Target - Select where the cell to start the range from.
    • Active Cell - Sets from the currently active cell
    • Specific Cell - Sets from the provided start cell address
  • Headers - Whether or not the data includes headers.