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.
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 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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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"