'%3e%3cpath%20d='M3,7.5C3,5.015%205.015,3%207.5,3L24.5,3C26.985,3%2029,5.015%2029,7.5L29,24.5C29,26.985%2026.985,29%2024.5,29L7.5,29C5.015,29%203,26.985%203,24.5L3,7.5ZM7.5,5C6.119,5%205,6.119%205,7.5L5,11L11,11L11,5L7.5,5ZM5,13L5,19L11,19L11,13L5,13ZM13,13L13,19L19,19L19,13L13,13ZM21,13L21,19L27,19L27,13L21,13ZM19,21L13,21L13,27L19,27L19,21ZM21,27L24.5,27C25.881,27%2027,25.881%2027,24.5L27,21L21,21L21,27ZM21,11L27,11L27,7.5C27,6.119%2025.881,5%2024.5,5L21,5L21,11ZM19,5L13,5L13,11L19,11L19,5ZM5,21L5,24.5C5,25.881%206.119,27%207.5,27L11,27L11,21L5,21Z'%20style='fill:rgb(82,96,105);fill-rule:nonzero;'/%3e%3c/g%3e%3c/svg%3e)
Read Range
Reads the value of a range from a spreadsheet as a DataTable. If the range is not specified, all used cells in the spreadsheet are read. If the range is specified as a cell, all used rows starting from that cell is read.
Properties
| Name | Description | Required |
|---|---|---|
| Has Headers | Specifies if the first row in the range should be considered column headers definitions. If set to false, the columns in the DataTable will use the following pattern "Col{number}", e.g.: Col1, Col2, Col3, etc. | |
| Headers Rows | Determines the number of rows that composes the header. The values of these rows are concatenated. | |
| Range | Specifies the range of cells to be read. If this value is not specified, all used cells of the spreadsheet is read. If the value consists of only one cell, all used rows in the spreadsheet are read starting from that cell. (Default: A1) | |
| Data Table | The output DataTable in which the read data is stored. | |
| Rows Per Record | Determines the number of rows that composes a single record. The row values are concatenated. | |
| Sheet Name | The name of the sheet from the workbook. | ☑️ |