Description

Inserts a new row into a spreadsheet.



Attributes

Input

  • 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”.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains and looks like:



  1. Add an Excel Sequence activity inside the initial Sequence.
  2. In the Excel Sequence File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. 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).
  4. 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.