Read Cell Value

Reads the value from a specific cell in the active Excel sheet.

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 read (e.g., A1, B5, C10).

Output

• Value - The value read from the cell. This is returned as text, preserving the cell's displayed format.

Options

This node has no additional options.

Example

Reading a single cell:

// File Descriptor: message.excel_fd
// Cell: "A1"
// Output stored in: message.Value

Reading product price:

// Cell: "D5"  // Price column
// The value is stored in message.Value

Reading multiple cells in sequence:

// 1. Read Cell Value
// Cell: "A1"
// Output: cell_a1

// 2. Read Cell Value
// Cell: "B1"
// Output: cell_b1

// 3. Read Cell Value
// Cell: "C1"
// Output: cell_c1

Reading a calculated cell:

// Cell: "E10"  // Contains =SUM(E1:E9)
// Returns the calculated result, not the formula

Tips

• This node returns the displayed text of the cell, not the underlying value. For example, if a cell contains the number 1234.56 but is formatted to show "$1,234.56", the node returns "$1,234.56".
• Use the active sheet. If you need to read from a different sheet, use Activate Sheet first.
• For reading multiple cells efficiently, consider using Get Range instead.
• To get formulas instead of values, use Get Formula.

Common Errors

Error	Solution
Cell cannot be empty	Provide a valid cell address (e.g., A1, B5)
Invalid File Descriptor	Ensure the Open Excel node was executed first
Invalid cell address	Use proper Excel cell notation (column letter + row number)