GetRangeByNumber
function GetRangeByNumber(nRow: number = null, nCol: number = null): ApiRange
Description
Returns an object that represents the selected range of the current sheet using the row/column coordinates for the cell selection.
Parameters
- nRow
number
null The row number.
- nCol
number
null The column number.
Returns
ApiRange
Try It
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRangeByNumber(1, 2).SetValue("42");