# Cells

### 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.

<details>

<summary><code>get the worksheet's cell</code></summary>

#### 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.

</details>

<details>

<summary><code>the cell reference is "A1"</code></summary>

#### 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"
```

</details>

### 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"
```
