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

jQuery Spreadsheet Resize Sheet

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Kendo UI Dojo
Change Theme
default
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Ocean Blue A11Y

Purple

Turquoise
Bootstrap Theme

Main

Bootstrap 3

Bootstrap 3 Dark

Main Dark

Nordic

Turquoise

Turquoise Dark

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Green

Green Dark

Lavender

Lavender Dark

Main Dark

Metro

Metro Dark

Moonlight

Opal

Opal Dark

Silver

Silver Dark

Uniform
Fluent Theme

Main
Launch Theme Builder

resize.html

Also available for:

Rows count

Columns count

$("#spreadsheet").kendoSpreadsheet({ rows: 50, columns: 15, excel: { // Required to enable saving files in older browsers proxyURL: "https://demos.telerik.com/kendo-ui/service/export" }, pdf: { proxyURL: "https://demos.telerik.com/kendo-ui/service/export" }, sheets: [ { name: "Food Order", rows: [ { height: 25, cells: [ { value: "ID", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { value: "Product", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { value: "Quantity", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { value: "Price", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { value: "Tax", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { value: "Amount", background: "rgb(167,214,255)", textAlign: "center", color: "rgb(0,62,117)" }, { background: "rgb(167,214,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 216321, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: "Calzone", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 1, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 12.39, format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C2*D2*0.2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C2*D2+E2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 546897, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: "Margarita", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 2, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 8.79, format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C3*D3*0.2", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C3*D3+E3", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 456231, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: "Pollo Formaggio", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 1, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 13.99, format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C4*D4*0.2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C4*D4+E4", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 455873, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: "Greek Salad", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 1, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 9.49, format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C5*D5*0.2", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C5*D5+E5", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 456892, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: "Spinach and Blue Cheese", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 3, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 11.49, format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C6*D6*0.2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C6*D6+E6", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 546564, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: "Rigoletto", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 1, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 10.99, format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C7*D7*0.2", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C7*D7+E7", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 789455, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: "Creme Brulee", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 5, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 6.99, format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C8*D8*0.2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C8*D8+E8", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 123002, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: "Radeberger Beer", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 4, textAlign: "center", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { value: 4.99, format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C9*D9*0.2", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { formula: "C9*D9+E9", format: "$#,##0.00", background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" } ] }, { cells: [ { value: 564896, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: "Budweiser Beer", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 3, textAlign: "center", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { value: 4.49, format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C10*D10*0.2", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { formula: "C10*D10+E10", format: "$#,##0.00", background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { index: 11, cells: [ { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" }, { background: "rgb(229,243,255)", color: "rgb(0,62,117)" } ] }, { index: 12, cells: [ { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" }, { background: "rgb(255,255,255)", color: "rgb(0,62,117)" } ] }, { height: 25, index: 13, cells: [ { background: "rgb(193,226,255)", color: "rgb(0,62,117)" }, { background: "rgb(193,226,255)", color: "rgb(0,62,117)" }, { background: "rgb(193,226,255)", color: "rgb(0,62,117)" }, { background: "rgb(193,226,255)", color: "rgb(0,62,117)" }, { value: "Tip:", background: "rgb(193,226,255)", color: "rgb(0,62,117)", textAlign: "right", verticalAlign: "bottom" }, { formula: "SUM(F2:F11)*0.1", background: "rgb(193,226,255)", color: "rgb(0,62,117)", format: "$#,##0.00", bold: "true", verticalAlign: "bottom" }, { background: "rgb(193,226,255)", color: "rgb(0,62,117)" } ] }, { height: 50, index: 14, cells: [ { index: 0, background: "rgb(193,226,255)", color: "rgb(0,62,117)", }, { index: 1, background: "rgb(193,226,255)", color: "rgb(0,62,117)", }, { index: 2, background: "rgb(193,226,255)", color: "rgb(0,62,117)", }, { index: 3, background: "rgb(193,226,255)", color: "rgb(0,62,117)", }, { index: 4, fontSize: 20, value: "Total Amount:", background: "rgb(193,226,255)", color: "rgb(0,62,117)", textAlign: "right" }, { index: 5, fontSize: 20, formula: "SUM(F2:F14)", background: "rgb(193,226,255)", color: "rgb(0,62,117)", format: "$#,##0.00", bold: "true" }, { index: 6, background: "rgb(193,226,255)", color: "rgb(0,62,117)" } ] } ], columns: [ { width: 100 }, { width: 215 }, { width: 115 }, { width: 115 }, { width: 125 }, { width: 155 } ] } ] }); $("#rowsCount").kendoNumericTextBox({ min: 1, max: 1000, decimals: 0, format: "n0", value: 4 }); $("#columnsCount").kendoNumericTextBox({ min: 1, max: 1000, decimals: 0, format: "n0", value: 5 }); $("#resize").click(function () { var rows = $('#rowsCount').data('kendoNumericTextBox').value(); var cols = $('#columnsCount').data('kendoNumericTextBox').value(); var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet"); var sheet = spreadsheet.activeSheet(); sheet.resize(rows, cols); }); .box-col .k-numerictextbox { max-width: 180px; } #resize{ margin-left: 14px; }

Description

The Kendo UI for jQuery Spreadsheet allows you to define the number of the rows and columns in the current sheet.

This demo shows how you can utilize the resize method to change the displayed number of rows and columns after initialization.

This Spreadsheet example is part of a unique collection of hundreds of jQuery demos, with which you can see all Kendo UI for jQuery components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in Kendo UI for jQuery Dojo or ThemeBuilder.

Description

The Kendo UI Spreadsheet Sheet supports the capability to change the number of its rows and columns, and increase its size after loading.

The resize functionality allows automatic sheet resizing on pasting more data than the current sheet size, plus flexible behavior when adding & deleting columns and rows from the toolbar.

Read more in the Spreadsheet Resize article.

jQuery Spreadsheet Resize Sheet

Description

Description

Support & Learning Resources

Additional Resources