Select Range
Object to select a range of cells to be read
Last updated
Was this helpful?
Object to select a range of cells to be read
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 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
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:
