Skip to main content

Get Cell Value

Retrieves the value from a specific cell in an Excel worksheet stored in OneDrive or SharePoint.

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 the ContinueOnError property is set to true, no error is caught when the project is executed even if a Catch node is used.

Input​

  • Client Id - The client ID from the Connect node (optional if using direct credentials).
  • Workbook Id - The workbook ID from Get Workbook or Create Workbook node.
  • Worksheet Name - Name of the worksheet to read from (e.g., Sheet1). Default is "Sheet1".
  • Cell Address - Cell address in A1 notation (e.g., A1, B2, C3, AA10).

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).

Output​

  • Value - The value in the specified cell. Can be text, number, boolean, or null.

Examples​

Read Single Cell:

// Input
Client Id: ${client_id}
Workbook Id: ${workbook_id}
Worksheet Name: "Sheet1"
Cell Address: "B5"

// Output - value
"Sales Total"

Read Numeric Value:

// Input
Cell Address: "D10"

// Output - value
1234.56

Read from Different Sheet:

// Input
Worksheet Name: "Monthly Data"
Cell Address: "A1"

// Output - value
"January 2025"

Typical Workflow:

Get Workbook
  → Get Cell Value (read header from A1)
  → Get Cell Value (read total from D10)
  → Use values in calculations

Cell Address Format​

Cell addresses use standard Excel A1 notation:

  • Single letter column + row number: A1, B2, Z99
  • Double letter columns: AA1, AB2, ZZ999
  • Case insensitive: a1 and A1 are equivalent

Use Cases​

  • Read specific values like totals, headers, or status flags
  • Extract individual data points for processing
  • Validate specific cell contents
  • Read configuration values from known cells
  • Check cell values before conditional operations

Tips​

  • Cell addresses are not case-sensitive (A1 = a1)
  • Returns null for empty cells
  • For reading multiple cells, use Get Range for better performance
  • Worksheet names are case-insensitive
  • If worksheet name is empty, defaults to "Sheet1"

Common Errors​

ErrInvalidArg - "Workbook ID cannot be empty"

  • Solution: Ensure you've called Get Workbook first and passed the workbook_id

ErrInvalidArg - "Cell address cannot be empty"

  • Solution: Provide a cell address in A1 notation (e.g., A1, B2, C3)

ErrNotFound - "Cell not found in worksheet"

  • Solution: Verify the worksheet name is correct and the cell address is valid

ErrGraph - "Microsoft Graph Error"

  • Solution: Check that the workbook is accessible and the worksheet exists