Get a Singular Table from an Excel Worksheet

Retrieves the only 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.

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

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the worksheet	Excel 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 a single table from a specified worksheet, using a reference to that worksheet.

Where does it go? This phrase should be written on a new line.

Does it require input data? ⛔ No — This phrase does not require input data.

Is it required? ✅ Yes — This phrase is required in the syntax.

Examples

1. Get the Excel Worksheet's Only Table

get the worksheet's only table