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