Get a Cell Value

Retrieves the value of a cell in an Excel worksheet.

Overview

This procedure retrieves the value of a specific cell in an Excel worksheet. You can use it to extract text, numbers, or formulas from a given worksheet, which can then be used for validation, further processing, or decision-making within your automation.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

get the worksheet's cell

What does it do?

Begins cell value retrieval from the worksheet.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the worksheet must be previously defined in the automation.

the cell reference is "A1"

What does it do?

Specifies which cell to retrieve.

Where does it go?

Indented under get the worksheet's cell where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace A1 with a cell reference in Excel format.

Example

the cell reference is "C1"

Examples

1. Get Cell Value by Reference

Retrieves the value from a specific cell.

get the excel's worksheet
get the worksheet's cell where
    the cell reference is "A1"

2. Get Cell from Named Worksheet

Gets a cell value from a specific worksheet.

get the excel's worksheet where
    the worksheet name is "Employees"
get the worksheet's cell where
    the cell reference is "C1"