Set Active Cell

Sets the active cell in the worksheet by address or relative movement from the current position.

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 Address - Cell address to activate (e.g., A1, B5). Required only when Target is set to "Specific".

Output

This node has no output.

Options

• Target - Movement direction or specific cell selection:
  • Specific - Activate a specific cell by address (requires Cell Address)
  • Up - Move one cell up from the current active cell
  • Down - Move one cell down from the current active cell
  • Right - Move one cell right from the current active cell
  • Left - Move one cell left from the current active cell
  • Row Start - Move to the first column of the current row
  • Row End - Move to the last used column of the current row
  • Next Row - Move to the first column of the next row

Example

Setting a specific cell as active:

// File Descriptor: message.excel_fd
// Cell Address: "D5"
// Target: Specific

Navigating down through cells:

// Target: Down
// Moves from current cell (e.g., A1) to the cell below (A2)

Processing rows sequentially:

// 1. Set Active Cell to A1
// Cell Address: "A1"
// Target: Specific

// 2. Read current cell value...

// 3. Move to next cell in row
// Target: Right

// 4. Read value...

// 5. Move to start of next row
// Target: Next Row

// Repeat for each row

Moving to row boundaries:

// Move to beginning of current row
// Target: Row Start

// Move to end of current row
// Target: Row End

Grid navigation:

// Start at A1
// Target: Specific, Cell Address: "A1"

// Move right
// Target: Right  // Now at B1

// Move down
// Target: Down   // Now at B2

// Move left
// Target: Left   // Now at A2

Tips

• Use relative movements (Up, Down, Left, Right) for processing data in loops.
• Row Start moves to column A of the current row.
• Row End moves to the last column with data in the current row.
• Next Row is equivalent to moving down and then to Row Start.
• This node only changes the active cell selection; it doesn't modify any data.

Common Errors

Error	Solution
Cell Address cannot be empty for specific target	Provide a cell address when using Specific target
Cannot move up from the first row	You're already at row 1
Cannot move left from the first column	You're already at column A
Invalid target option	Select a valid target from the dropdown
Invalid File Descriptor	Ensure the Open Excel node was executed first