Skip to main content

Set Cell Value

Sets the value of a cell in an Excel spreadsheet.

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 Excel file descriptor ID. This ID is generated by the Open Excel or the Create Excel node.
  • Cell - The cell address in which to set the value. (e.g. C3)
  • Value - The value to set in the cell.

Options​

  • Target - The target location where to set the value. Available options are "Active Cell" or "Specific Cell".

  • Format - The format of the value to set in the cell. Available options are "String", "Number", "DateTime", "Boolean".

Notes:​

  • If the target is set to "Active Cell" then the input for "Cell" will be ignored.