Description

Reads the content of the specified column and returns the value as an output.



Attributes

Output 

  • Values - The name of the variable where the value would be stored.

Input

  • Column - The column where the value would be read from.

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



  1. Add an Excel Sequence activity inside a Sequence.
  2. In the File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. Create an (IEnumerable<Object>) variable called names.
  4. Inside the Excel Sequence, add a Read Column activity, and in the Values field under Properties, add names.
  5. In the Worksheet field, write "Info", and in the Column field, write "A".
  6. Next to Read Column, add a For Each activity, and in the Values field, type names.
  7. Inside the For Each Activity, add a Write Line activity, and in the Text field, write item.ToString

    The use case should look as the following screenshot:



The output should look like this in the Output panel: