Insert a Table

Inserts a table into an Excel worksheet.

Overview

This procedure inserts a table into an Excel worksheet. The output is a modified worksheet with the table inserted.

The modified worksheet is not saved into the original Excel file.

Prerequisite Data

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

Data Name	Data Type
the worksheet	Excel Worksheet
the table	Table

Syntax

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

insert the table into the worksheet

What does it do?

References an Excel worksheet to insert a table into.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

⛔ No — This phrase does not require input data.

the location is

What does it do?

Specifies a cell location to insert the table at.

Where does it go?

This phrase should be indented beneath insert the table into the worksheet.

Is it required?

✅ Yes — This phrase is required in the syntax.

Does it require input data?

✅ Yes — A Text value should be specified.

the headers are

What does it do?

Optionally specifies the table headers.

Where does it go?

This phrase should be indented beneath insert the table into the worksheet.

Is it required?

🌟 No — This phrase is optional in the syntax.

Does it require input data?

✅ Yes — List of texts

Examples

1. Insert a Table by Specifying Location

insert the table into the worksheet
    the location is B2