This procedure inserts a table into an Excel worksheet. The output is a modified worksheet with the table inserted.
Note: The modified worksheet is not saved into the original Excel file.
These required data elements must be present in the automation before using the procedure.
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
insert the table in 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.
Does it require input data? ⛔ No — This phrase does not require input data.
Is it required? ✅ Yes — This phrase is required in the syntax.
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 in the worksheet.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? ✅ Yes — This phrase is required in the syntax.
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 in the worksheet.
Does it define new data? ✅ Yes — List of texts
Is it required? 🌟 No — This phrase is optional in the syntax.
insert the table in the worksheet
the location is B2
