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: