Select Range

Object to select a range of cells to be read

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 the Excel sheet
Select Range	Allows you to enter a range of cells to be selected
Starting Column	Initial column of the cell range that will be read
Final Column	Final column of the cell range that will be read
Starting Row	Initial row of the cell range that will be read
Final Row	Initial row of the cell range that will be read
Return type	Field to inform the desired return type: Data Table or List
Range has header	Option for selecting a header
Include Header	Button to include the header
Header Name	Field to inform the header name
Type	Select the field type

Example

To read the data of an Excel spreadsheet file you can select a range of cells:

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, click on the "Select Range" option, enter the desired columns and rows and define the return type.

4 - The working area will look like this: