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

Resize

methods

Resize the sheet to accommodate the specified number of rows and columns. If the new dimensions are smaller than the current ones, any existing data in the rows or columns that are to be removed will be discarded.

resize

Parameters:newRowsNumber

The new number of rows.

newColumnsNumber

The new number of columns.

<div id="spreadsheet"></div>
<script type="text/javascript" charset="utf-8">
    $("#spreadsheet").kendoSpreadsheet({ rows: 10, columns: 5 });
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    var sheet = spreadsheet.activeSheet();

    sheet.resize(1000, 30);
    // the sheet will now contain 1000 rows and 30 columns
</script>