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