# Get a Singular Table from an Excel Worksheet

### Overview

This procedure extracts and retrieves a table from an Excel worksheet. It is meant to be used when the worksheet contains only a single table.

{% hint style="warning" %}
This procedure raises an exception if multiple tables are found in the worksheet.
{% endhint %}

### 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 only table</code></summary>

#### What does it do?

Retrieves the single table from the current 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 defined in the automation.

</details>

### Examples

#### 1. Get Single Table from Worksheet

Retrieves the only table from the current worksheet.

```
get the worksheet's only table
```