Edit Cells

Object for Excel data editing

Settings

This object depends on the "New Excel" or "Open Excel" object to work.

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.

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:

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

4 - The working area will look like this:

Last updated

Was this helpful?