This procedure inserts a new row into an existing Excel worksheet at a specified row number. Existing rows are shifted down. This allows you to add rows without overwriting existing content 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.
insert a row into the worksheet where
What does it do? References an Excel worksheet to insert a row 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 row number is
What does it do? Specifies a row number to insert the row at.
Where does it go? This phrase should be indented beneath insert a row into the worksheet where.
Does it require input data? ✅ Yes — A Number value should be specified.
Is it required? ✅ Yes — This phrase is required in the syntax.
the values are
What does it do? Optionally species the values to insert into the new row. An empty row will be added if not specified.
Where does it go? This phrase should be indented beneath insert a row into the worksheet where.
Does it define new data? ✅ Yes — List
Is it required? 🌟 No — This phrase is optional in the syntax.
Examples
1. Insert a Row by Specifying a Row Number
insert a row into the worksheet where
the row number is 2
2. Insert a Row by Specifying a Row Number and Values
insert a row into the worksheet where
the row number is 2
the values are "Earth", "Water", "Fire", "Air"
