New to Kendo UI for jQuery? Start a free 30-day trial

Range

methods

Returns a Range for the given range specification.

range

Parameters:refString

rowIndexNumber

columnIndexNumber

Returns:kendo.spreadsheet.Range

a range object, which may be used to manipulate the cell state further.

<div id="spreadsheet"></div>
<script type="text/javascript" charset="utf-8">

    $("#spreadsheet").kendoSpreadsheet();

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    var sheet = spreadsheet.activeSheet();

    // set contents of the A1:B2 range
    sheet.range("A1:B2").values([ [1, 2], [2, 3] ]);
</script>

<div id="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet();

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    var sheet = spreadsheet.activeSheet();

    // select the B3:C6 range
    sheet.range(2,1,4,2).select();
</script>