Description

Reads the content of the specified cell or range of cells and returns the value as an output.



Attributes

Output

  • Value - The String variable where the formula would be stored.

Input

  • Column - The column where the formula would be read.

  • Row - The row where the formula would be read.

  • 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 the initial Sequence.
  2. In the Excel Sequence File Path field, search for and select your Spreadsheet document by clicking the browse button.
  3. Create a String variable and name it formula.
  4. Inside the Excel Sequence, add a Read Cell Formula activity, and in the Value field under Properties, add the formula variable.
  5. In the Read Cell Formula Worksheet field, write "Sheet1" (or the name of the sheet you would use).
  6. In the Read Cell Formula Column field, write "B", and in the Row field, write "5". 
  7. After the Read Cell Formula, add a Write Line activity.
  8. In the Write Line Text field, add the formula variable. 

    The use case should look as the following screenshot:



The output should look like this in the Output panel: