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

Values

methods

Gets or sets the values of the range cells. The argument should be an array of arrays which match the dimensions of the range.

This method clears the formulas on every cell.

values

Parameters:valuesArray

The cell values.

Returns:Array

the cell values.

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

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

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

    var sheet = spreadsheet.activeSheet();

    var values = [
        [ 1, 2, 3 ],
        [ 4, 5, 6 ],
        [ 7, 8, 9 ]
    ];

    sheet.range("A1:C3").values(values);
</script>