This procedure locates and extracts a table from an Excel worksheet.
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.
extract a table from the worksheet where
What does it do?
References an Excel worksheet from which a table is to be extracted from.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required in the syntax.
⛔ No — This phrase does not require input data.
the description is
What does it do?
Describes the table to be extracted. Refer to Example 1 for details.
Where does it go?
This phrase should be indented beneath extract a table from the worksheet where.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
the location is
What does it do?
Specifies a range of cells where the table is located. Refer to Example 2 for details.
Where does it go?
This phrase should be indented beneath extract a table from the worksheet where.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
the first header is
What does it do?
Specifies the name of the header marking the start of the table. Refer to Example 3 for details.
Where does it go?
This phrase should be indented beneath extract a table from the worksheet where.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
the last header is
What does it do?
Specifies the name of the header marking the end of the table. Refer to Example 3 for details.
Where does it go?
This phrase should be indented beneath extract a table from the worksheet where.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
extract a table from the worksheet where
the description is "This is a table which calculates housing cost information"
extract a table from the worksheet where
the location is "A1:B10"
extract a table from the worksheet where
the first header is "Name"
the last header is "Age"
