Description
Updates a row specified on the Excel Sequence.
Attributes
Input
Row - The row to be updated.
Values - The value to be placed on the specified row.
Worksheet - The name of the sheet to be updated. By default, it is set to “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:
- Add an Excel Sequence activity inside the initial Sequence.
- In the Excel Sequence File Path field, search for and select your Spreadsheet document by clicking the browse button.
- Inside the Excel Sequence, add an Update Row activity.
- In the Update Row Worksheet field, write "Sheet1" (or the name of the sheet you would use).
- In the Update Row Row field, write "3".
- In the Update Row Values field, write {"History","88"}.
The use case should look as the following screenshot:
After execution, the values of Row 3 should be updated with the specified values.