Get Data from Range#
Get data from a range.
| Document R7 | [Link] Document R7, which was obtained when creating, opening a file, or connecting to the document. |
| Sheet | [Number/Text] ID (serial number) or name of the sheet where the required cell is located. Numbering starts from 1. |
| Range | [Text] Range of cells from which to read data (for example, "B4", "A1:C4"). If only the starting cell is specified, data will be read until the end of filled rows/columns (cells are considered filled if formatted or if there is a value in the cell). The value also accepts * for patterns (for example, "B4:*", "A1:*4", "A1:E*"). |
| Formatted Values | When enabled, returns the formatted value of the cell. |
| Has Headers | If enabled, the first row of the read range will be treated as the header of the table columns. |
| Consider Empty | If enabled, empty cell values will be counted when calculating the number of rows and/or columns. |
| Result | [Data Table] Returns the contents of the range of cells. |
| Error Handling Level | Select the error handling level. Possible values:
If "Default" is selected, the value from the "Start" block of this diagram will be used. |
| Message Level | Select the message level that blocks will output during operation. Possible values:
If "Default" is selected, the value from the "Start" block of this diagram will be used. |
| Error Text | [Text] Returns detailed information about the error in case of incorrect execution of the block's work. |