Set Cell Value
This action can be used to set the value of a specific Excel cell.
Properties
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!
Last updated
