Map Object
Represents an RVL Map object and all its operations. The same operations are used by the RVL runtime implicitly to read the cell value or iterate through the Map.
DoMoveToRow(/**Number*/ colInd)
Moves to a given row.
rowInd
Row index (or name) to set active.
DoSequential()
Advances to the next row in the range. The range is either set by SetRange or it is the default range that includes all rows on the sheet except first row which is considered to contain column names. When the end of the range is reached, DoSequential rewinds back to the first row in the range and returns 'false'.
Returns 'false' if being called when active row is the last row or the spreadsheet is not attached, 'true' - otherwise.
DoMoveToColumn(/**Number|String*/colInd)
Moves to a given column.
colInd
Column index (or name) to set active.
** GetCell(/**Number|String*/ columnId, /**Number*/ rowId)
**
Gets a cell value by its coordinates. It returns the current cell value after DoSequental or DoRandom if the parameters are not set.
[columnId]
Column index or name. If not set ActiveColumn is used.
[rowId]
Row index. If not set ActiveRow is used.
** GetColumnCell(/**Number*/ rowId)
**
Gets cell value by its coordinates. Returns current cell value after DoSequental. If not set ActiveColumn is used.
[rowId]
Row index. If not set ActiveRow is used.
** GetColumnCount()
**
Gets columns count.
Returns Number of columns in the spreadsheet.
** GetColumnIndexByName(/**String*/name)
**
Gets column name.
name
Column name.
Returns column index if found, or -1.
** GetColumnName(/**Number*/ ind)
**
Gets column name.
ind
Column index.
Returns Name of column in the spreadsheet.
** GetRowIndexByName(/**String*/name)
**
Gets row name.
name
Row name.
Returns row index if found, or -1.
** GetRowCell(/**Number|String*/ columnId)
**
Gets cell value for current row. Returns current cell value after DoSequental. ActiveRow is used.
[columnId]
Column index or name. If not set ActiveColumn is used.
** GetRowName(/**Number*/ ind)
**
Gets row name.
ind
Row index.
Returns Name of row in the map.
** GetValue(/**Number|String*/ rowOrColumnNameOrId)
**
Gets cell value by its name or id. Returns current cell value after DoSequental. If it is Rows or Table then the parameter needs to be a column name or index, and ActiveRow is used. If it is Columns then the parameter needs to be a row name or index, and ActiveRow is used.
[rowOrColumnNameOrId]
Row or Column index or Name.