# Read Excel Data

## Settings 

{% hint style="info" %}
This object depends on the "**New Excel**" or **"Open Excel"** object to work.
{% endhint %}

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MWu92CLuE16msd8INww%2F-MWuBdZ9oL1Lf06BHgtX%2Fimage.png?alt=media\&token=426566bc-0309-4a17-b7bf-a32b74c2759f)

| Field                              | Descriptive                                                                         |
| ---------------------------------- | ----------------------------------------------------------------------------------- |
| Title                              | Object title                                                                        |
| Object Identifier Name             | Singular object name for this object                                                |
| Select Main Object                 | Option to select an Excel spreadsheet                                               |
| Use the selected cells?            | Option to search the information of the selected cells                              |
| Action regarding Rows with no Data | This option determines what the robot should do when it finds rows without content. |
| Select Range                       | Allows you to enter a range of cells to be selected                                 |
| Cell                               | Field to inform the desired cell                                                    |

{% hint style="info" %}
See how to proceed if the "**Select Range**" option is selected, by clicking [HERE](https://docs.roboteasy.tech/studio-en/studio/objetos/excel/ler-dados/untitled).
{% endhint %}

{% hint style="info" %}
**Action regarding Rows with no Data**

**Available options:** 

**Continue:** This indicates that the row will still be read. 

**Ignore:** This indicates that the row will be ignored. 

**Stop**: This indicates that the reading will be terminated, i.e. reading will only occur so long no empty rows are found.
{% endhint %}

## Example

To read the data of an Excel spreadsheet file, you must have a pre-existing file and:

1 - Select the "**Open Excel**" object from the "**Excel**" menu and drag it to your working area.

* First you must define a unique name for the object in the "**Object Identifier Name**" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUilHABYUbWKZ1K0Wjo%2F-MUjsShGbOKhHwjEDRKi%2FabrirExcel.gif?alt=media\&token=c417db53-09fc-44c5-b028-c3141e6bf9ae)

2 - Then select the "**Select Sheet**" object from the **"Excel"** menu, the main object defined when opening the Excel file and then define the name of the sheet you wish to select:

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUilHABYUbWKZ1K0Wjo%2F-MUjwgUQmx7K4IsJmU2K%2FselecionarPlanilha.gif?alt=media\&token=d6add6f8-896a-4e86-839b-e4a40d3210a7)

3 - Then select the "**Read Excel Data**" object from the "**Excel**" menu, enter a name for the reading object, select the main object and enter the desired cell.

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUy1yKbdyNgcneAPj71%2F-MUyr74IXdfNNDDQB79m%2FlerDadosExcel.gif?alt=media\&token=63d72c00-0b07-45cb-9b61-565ec538a042)

4 - The working area will look like this:

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUy1yKbdyNgcneAPj71%2F-MUyrGkS4dV1Ujg4LxLl%2Fimage.png?alt=media\&token=9035cdaf-a3c1-4611-8c6b-139becd5e812)


---

# 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.roboteasy.tech/studio-en/studio/objetos/excel/ler-dados.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.