Set Cell Value

This activity can be used to set the value of a specific Excel cell.

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

  • Value: a regular C# expression that is evaluated. The result is stored in the target Excel cell.

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

  • Set exchange rate in a cell and use it as an absolute address in other calculations

  • Perform a calculation (e.g. sum, average, etc.) in the specified cell

  • Copy a table from a different source and paste it in an excel file

Examples of Using Set Cell Value

Example

In this example, the robot will access an Excel file, change a value, and then close the Excel file.

Watch the robot in action:

You can see how the Set 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 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!