Set Cell Value

Sets the value of a specific cell in the active Excel sheet with type formatting support.

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 the 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 the Catch node is used.

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• Cell - Cell address to write to (e.g., A1, B5, C10).
• Value - Value to write to the cell.

Output

This node has no output.

Options

• Format - Data type format for the value:
  • string - Stores the value as text
  • number - Stores the value as a number
  • boolean - Stores the value as a boolean (TRUE/FALSE)

Example

Writing text to a cell:

// File Descriptor: message.excel_fd
// Cell: "A1"
// Value: "Product Name"
// Format: string

Writing a number:

// Cell: "B2"
// Value: "1234.56"
// Format: number
// Excel will treat this as a numeric value for calculations

Writing a boolean:

// Cell: "C3"
// Value: "true"
// Format: boolean
// Excel will display TRUE in the cell

Preventing leading zeros from being removed:

// Cell: "A1"
// Value: "00123"
// Format: string
// Keeps the leading zeros by storing as text

Writing calculated values:

// Get a value from another source
// Cell: "D5"
// Value: message.calculated_total
// Format: number

Tips

• Choose the correct Format to ensure Excel treats the data appropriately.
• Use string format for data like product codes (e.g., "00123") to preserve leading zeros.
• Use number format for numeric calculations to enable Excel formulas to work with the data.
• Use boolean format for TRUE/FALSE values in conditional logic.
• The cell retains any existing formatting (colors, borders, etc.) but the value is replaced.

Common Errors

Error	Solution
Cell cannot be empty	Provide a valid cell address (e.g., A1, B5)
Value cannot be empty	Provide a value to write to the cell
Format must be selected	Choose a format: string, number, or boolean
Invalid File Descriptor	Ensure the Open Excel node was executed first
Invalid number format	Ensure the value can be parsed as a number when using number format
Invalid boolean format	Use "true" or "false" when using boolean format