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:

PreviousClear Spreadsheet NextSelect Range

Last updated 2 years ago

Was this helpful?