Read Excel Data

Object for Excel data reading

Settings

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

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

See how to proceed if the "Select Range" option is selected, by clicking HERE.

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.

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.

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 "Read Excel Data" object from the "Excel" menu, enter a name for the reading object, select the main object and enter the desired cell.

4 - The working area will look like this: