Description

Updates a cell or range of cells specified on the Excel Sequence.



Attributes

Input

  • Range - The range of cells to be updated.

  • Value - The value to be placed on the specified cell or range of cells.

  • 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:



  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 clicking the browse button.
  3. Inside the Excel Sequence activity, add an Update Cell activity.
  4. In the Update Cell Worksheet field, write "Employees" (or the name of the sheet you would use).
  5. In the Update Cell Range field, type "B2".
  6. In the Update Cell Value field, write "23". 

    The use case should look as the following screenshot:



After execution, the value of cell B2 should now be 23 instead of 22.