Inserts a new row into a spreadsheet.
Row - The name of the row where the row would be added.
Worksheet - The name of the sheet to be updated. By default, it is set as “Sheet1”.
ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.
DisplayName - Renames the activity.
For this example, this is what the sample Spreadsheet contains and looks like:
- Add an Excel Sequence activity inside the initial Sequence.
- In the Excel Sequence File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
- After the Excel Sequence, add an Insert Row activity, and in the Worksheet field, write "Sheet1" (or the name of the sheet you would use).
- In the Row field, write "4".
The use case should look as the following screenshot.
After executing, a new row should be added in Row 4.