Read Excel Data
Object for Excel data reading
Last updated
Was this helpful?
Object for Excel data reading
Last updated
Was this helpful?
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.
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:
