Description

Updates a column specified on the Excel Sequence.



Attributes

Input

  • Column - The column or name of the column to be updated.

  • Values - The value to be placed on the specified column.

  • 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, first, clicking the browse button.
  3. Inside the Excel Sequence, add an Update Column activity.
  4. In the Update Column Worksheet field, write "Sheet1" (or the name of the sheet you would use).
  5. In the Update Column Column field, write "B".
  6. In the Update Column Values field, write {"Grade","93","87","85"}. 

    The use case should look as the following screenshot:



After execution, the values of column B should be updated with the specified values: