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:

Last updated

Was this helpful?