> For the complete documentation index, see [llms.txt](https://docs.tailent.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tailent.com/actions/tap-actions/excel/read-range.md).

# Read Range

This action is used to read a given range of the excel document.

## **Properties**

<figure><img src="/files/MGBg0vTryoSZQeMOgJKO" alt=""><figcaption></figcaption></figure>

### **Input**

* **Excel Document**: File name for the target Excel document.
* **WorkSheet**: The target worksheet name.
* **Cell Range**: The target range.
* **Use Header:** Specifies if the action should use the first row in defining the column names.\
  True/False.

{% hint style="info" %}
The target range needs to be specified as an "A1" notation. Example "A1:D5". If left empty, the whole sheet will be captured.
{% endhint %}

{% hint style="info" %}
If the WorkSheet property is left empty, the first sheet from the active document will be chosen.
{% endhint %}

### Output

* **Output:** The name of the variable used to store the value.

{% hint style="info" %}
The variable must be a DataTable.
{% endhint %}

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

* Extract only the relevant cells from an excel file.

### **Examples of Using Read Range**

**Example**&#x20;

Watch the robot in action:

{% embed url="<https://www.youtube.com/watch?v=yQ27B5NhaGI>" %}

You can check and download the example from here:

{% file src="/files/xxnjH7g1NLRHboBvZk4A" %}