values

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.

Parameters

values Array

The cell values.

Returns

Array the cell values.

Example

    <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>