Get Cell Value

This activity can be used to retrieve the value of the specified Excel Cell object.

Properties

mceclip0.png

Input

  • Excel Document: file name for the target Excel document.

  • WorkSheet: name of the target worksheet within the target Excel document

  • Row: the row index of the target cell

  • Column: the column index of the target cell.

Output

  • Output: the name of the variable used to store the retrieved cell value.

Misc

  • Display Name: action display name in your implementation project

  • Wait Before: number milliseconds robot to wait before executing the action.

  • Wait After: number milliseconds robot to wait until moving to the next action.

  • Abort on Error: True/False

  • Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

  • Get values of certain Excel Cells in order to use them in other calculations

  • Get values of certain Excel Cells in order to include them in an email text

  • Get values of certain Excel Cells as part of a process that requests filling in fields/forms from other applications

Examples of Using Get Cell Value

Example

In this example, the robot will access an Excel file and capture a cell value.

Watch the robot in action:

You can see how the Get Cell Value activity is used in an example that incorporates multiple activities. You can check and download the example from here:

The article doesn't fully answer your question, or you want to find out more? Ask your question in the comments, on our community forum, or contact our support team or your account manager. Whatever works for you, your question will find its answer soon!