# Set Cell Value

&#x20;This action can be used to set the value of a specific Excel cell.

## **Properties**

![](/files/-MfgCC2WAcwwcSRR90ma)

### **Input**

### &#x20;

* **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.&#x20;

## **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:

{% embed url="<https://youtu.be/yKBlPBnmbg4>" %}

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:

{% file src="/files/-MT2NRqor7Bu\_kcCcmK5" %}
Set Cell Value sample project
{% endfile %}

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!


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tailent.com/actions/tap-actions/excel/set-cell-value.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
