Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
XL.Sheet.RowColToAddr
Converts row and column to a cell reference.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
XL | 3.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Sheet.RowColToAddr"; bookRef; sheetIndex; Row; Column; rowRelative; colRelative ) More
Parameters
Parameter | Description | Example |
---|---|---|
bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
sheetIndex | The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
Row | The row for the cell. First row has index 0. | $row |
Column | The column for the cell. First column has index 0. | $column |
rowRelative | Whether to use relative row. Pass 1 for relative and 0 for absolute. | 1 |
colRelative | Whether to use relative column. Pass 1 for relative and 0 for absolute. | 1 |
Result
Returns address value or error.
Description
Converts row and column to a cell reference.Examples
Calculates address and returns "$D$18":
MBS( "XL.Sheet.RowColToAddr"; $book; $sheet; 17; 3; 0; 0)
Calculates address and returns "D18":
MBS( "XL.Sheet.RowColToAddr"; $book; $sheet; 17; 3)
See also
This function checks for a license.
Created 18th August 2014, last changed 18th August 2014