New to Telerik UI for ASP.NET MVC? Download free 30-day trial

Resize Sheet

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
default
Themes & Swatches

SASS

LESS

Launch Theme Builder
Default Theme

Main

Main Dark

Nordic

Ocean Blue

Purple

Turquoise
Bootstrap Theme

Main

Main Dark

Nordic

Urban

Vintage
Material Theme

Main

Arctic

Lime Dark

Main Dark

Nova
Classic Theme

Main

Main Dark

Opal

Silver
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

                        resize.cshtml
                    
                        ResizeController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Rows count

Columns count

kendo.syncReady(function(){jQuery("#spreadsheet").kendoSpreadsheet({"columns":15,"excel":{"proxyURL":"/aspnet-mvc/spreadsheet/index_proxy"},"pdf":{"proxyURL":"/aspnet-mvc/spreadsheet/index_proxy"},"rows":50,"sheets":[{"name":"Food Order","columns":[{"width":100},{"width":215},{"width":115},{"width":115},{"width":125},{"width":155}],"rows":[{"cells":[{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"ID"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"Product"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"Quantity"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"Price"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"Tax"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"center","value":"Amount"},{"background":"rgb(167,214,255)"}],"height":25},{"cells":[{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":216321},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","value":"Calzone"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":1},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":12.39},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C2*D2*0.2"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C2*D2+E2"},{"background":"rgb(255,255,255)"}]},{"cells":[{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":546897},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","value":"Margarita"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":2},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":8.79},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C3*D3*0.2"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C3*D3+E3"},{"background":"rgb(229,243,255)"}]},{"cells":[{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":456231},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","value":"Pollo Formaggio"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":1},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":13.99},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C4*D4*0.2"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C4*D4+E4"},{"background":"rgb(255,255,255)"}]},{"cells":[{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":455873},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","value":"Greek Salad"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":1},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":9.49},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C6*D6*0.2"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C5*D5+E5"},{"background":"rgb(229,243,255)"}]},{"cells":[{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":456892},{"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)","textAlign":"center","value":3},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":11.49},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C6*D6*0.2"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C6*D6+E6"},{"background":"rgb(255,255,255)"}]},{"cells":[{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":546564},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","value":"Rigoletto"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":1},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":10.99},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C7*D7*0.2"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C7*D7+E7"},{"background":"rgb(229,243,255)"}]},{"cells":[{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":789455},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","value":"Creme Brulee"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":5},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":6.99},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C8*D8*0.2"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C8*D8+E8"},{"background":"rgb(255,255,255)"}]},{"cells":[{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":123002},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","value":"Radeberger Beer"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","textAlign":"center","value":4},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":4.99},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C9*D9*0.2"},{"background":"rgb(229,243,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C9*D9+E9"},{"background":"rgb(229,243,255)"}]},{"cells":[{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":564896},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","value":"Budweiser Beer"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","textAlign":"center","value":3},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","value":4.49},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C10*D10*0.2"},{"background":"rgb(255,255,255)","color":"rgb(0,62,117)","format":"$#,##0.00","formula":"C10*D10+E10"},{"background":"rgb(255,255,255)"}]},{"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":11},{"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)"}],"index":12},{"cells":[{"background":"rgb(167,214,255)"},{"background":"rgb(167,214,255)"},{"background":"rgb(167,214,255)"},{"background":"rgb(167,214,255)"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","textAlign":"right","value":"Tip"},{"background":"rgb(167,214,255)","color":"rgb(0,62,117)","bold":true,"format":"$#,##0.00","formula":"SUM(F2:F11)*0.1"},{"background":"rgb(167,214,255)"}],"index":13},{"cells":[{"background":"rgb(193,226,255)","index":0},{"background":"rgb(193,226,255)","index":1},{"background":"rgb(193,226,255)","index":2},{"background":"rgb(193,226,255)","index":3},{"background":"rgb(193,226,255)","color":"rgb(0,62,117)","fontSize":20,"index":4,"textAlign":"right","value":"Total Amount"},{"background":"rgb(193,226,255)","color":"rgb(0,62,117)","fontSize":20,"bold":true,"format":"$#,##0.00","formula":"SUM(F2:F14)","index":5},{"background":"rgb(193,226,255)","index":6}],"height":50,"index":14}]}],"toolbar":{"home":["open","exportAs",["cut","copy","paste"],["bold","italic","underline"],"hyperlink","insertComment","insertImage","backgroundColor","textColor","borders","fontSize","fontFamily","alignment","textWrap",["formatDecreaseDecimal","formatIncreaseDecimal"],"format","merge","freeze","filter","toggleGridlines"],"insert":[["addColumnLeft","addColumnRight","addRowBelow","addRowAbove"],["deleteColumn","deleteRow"]],"data":["sort","filter","validation"]}});}); $("#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 ASP.NET MVC 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.

Resize Sheet

Themes & Swatches

Description

Support & Learning Resources