Edit this page

range

Returns a Range for the given range specification.

Parameters

ref String

A1 or RC notation reference of the cells.

Returns

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

Example

<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>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy