# Edit Cells

## 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-MZJJvwGzWl00gRodMhc%2F-MZJLZw-binwPYiSAdVU%2Fimage.png?alt=media\&token=b6459830-bbdb-4ad9-afa6-0c76b3fddfad)

| Field              | Descriptive                               |
| ------------------ | ----------------------------------------- |
| Title              | Object title                              |
| Select Main Object | Option for selecting an Excel spreadsheet |
| Column             | Column number for editing (ascending)     |
| Row                | Row number for editing (ascending)        |
| Value              | The new value for the cell                |
| Type               | Cell type                                 |

## Example

To edit data in an Excel spreadsheet file, you must have a pre-existing file:

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-MUtPOcJDeAN2zbG0lMT%2F-MUtStPjVHXqPAqXLB7O%2FselecionarPlanilha.gif?alt=media\&token=884e4e0c-09a4-4892-90c1-5eee84a0d7a1)

3 - Then select the object "**Edit Cell**" from the "**Excel"** menu 

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUk1oc5IKsoE5NirPIQ%2F-MUk6DOJ3LD_tQHZRaCO%2FmanipularDados.gif?alt=media\&token=aca41597-43e4-4e0c-a924-0aa3dc9464de)

4 - The working area will look like this:

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MUtPOcJDeAN2zbG0lMT%2F-MUteNcS69wethBc7Xps%2Fimage.png?alt=media\&token=ae1106bb-9308-499d-a89a-9868fad69a18)