Get a Singular Table from an Excel Worksheet

Retrieves the single table from a 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.

This procedure raises an exception if multiple tables are found in the worksheet.

Syntax

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

get the worksheet's only table

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.

Examples

1. Get Single Table from Worksheet

Retrieves the only table from the current worksheet.

get the worksheet's only table