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

ASP.NET MVC Spreadsheet Server Import and Export

Loading Demo...

EXAMPLE
VIEW SOURCE
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

                        server_side_import_export.cshtml
                    
                        Server_Side_Import_ExportController.cs
                    
                        Sheets settings

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Export

Import

kendo.syncReady(function(){jQuery("#spreadsheet").kendoSpreadsheet({"sheets":[{"activeCell":"C6:C6","name":"Products","columns":[{"index":0,"width":280},{"index":1,"width":120},{"index":2,"width":120},{"index":3,"width":120}],"frozenColumns":0,"frozenRows":0,"mergedCells":[],"rows":[{"cells":[{"background":"#00b050","color":"#ffffff","fontSize":13,"bold":true,"index":0,"textAlign":"center","verticalAlign":"center","value":"Product"},{"background":"#00b050","color":"#ffffff","fontSize":13,"bold":true,"index":1,"textAlign":"center","verticalAlign":"center","value":"Unit Price"},{"background":"#00b050","color":"#ffffff","fontSize":13,"bold":true,"index":2,"textAlign":"center","verticalAlign":"center","value":"Units in Stock"},{"background":"#00b050","color":"#ffffff","fontSize":13,"bold":true,"index":3,"textAlign":"center","verticalAlign":"center","value":"Discontinued"}],"height":40,"index":0},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Chai"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":18},{"background":"#f2f2f2","color":"#000000","index":2,"value":39},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":1},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Chang"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":19},{"background":"#ffffff","color":"#000000","index":2,"value":17},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":2},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Aniseed Syrup"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":10},{"background":"#f2f2f2","color":"#000000","index":2,"value":13},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":3},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Chef Anton\u0027s Cajun Seasoning"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":22},{"background":"#ffffff","color":"#000000","index":2,"value":53},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":4},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Chef Anton\u0027s Gumbo Mix"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":21.35},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":0},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":5},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Grandma\u0027s Boysenberry Spread"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":25},{"background":"#ffffff","color":"#000000","index":2,"value":120},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":6},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Uncle Bob\u0027s Organic Dried Pears"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":30},{"background":"#f2f2f2","color":"#000000","index":2,"value":15},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":7},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Northwoods Cranberry Sauce"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":40},{"background":"#ffffff","color":"#000000","index":2,"value":6},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":8},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Mishi Kobe Niku"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":97},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":29},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":9},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Ikura"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":31},{"background":"#ffffff","color":"#000000","index":2,"value":31},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":10},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Queso Cabrales"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":21},{"background":"#f2f2f2","color":"#000000","index":2,"value":22},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":11},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Queso Manchego La Pastora"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":38},{"background":"#ffffff","color":"#000000","index":2,"value":86},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":12},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Konbu"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":6},{"background":"#f2f2f2","color":"#000000","index":2,"value":24},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":13},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Tofu"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":23.25},{"background":"#ffffff","color":"#000000","index":2,"value":35},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":14},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Genen Shouyu"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":15.5},{"background":"#f2f2f2","color":"#000000","index":2,"value":39},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":15},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Pavlova"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":17.45},{"background":"#ffffff","color":"#000000","index":2,"value":29},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":16},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Alice Mutton"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":39},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":0},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":17},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Carnarvon Tigers"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":62.5},{"background":"#ffffff","color":"#000000","index":2,"value":42},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":18},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Teatime Chocolate Biscuits"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":9.2},{"background":"#f2f2f2","color":"#000000","index":2,"value":25},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":19},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Sir Rodney\u0027s Marmalade"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":81},{"background":"#ffffff","color":"#000000","index":2,"value":40},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":20},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Sir Rodney\u0027s Scones"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":10},{"background":"#f2f2f2","color":"#000000","index":2,"value":3},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":21},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Gustaf\u0027s Knackebrod"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":21},{"background":"#ffffff","color":"#000000","index":2,"value":104},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":22},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Tunnbrod"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":9},{"background":"#f2f2f2","color":"#000000","index":2,"value":61},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":23},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Guarana Fantastica"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":4.5},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":20},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":24},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"NuNuCa Nuss-Nougat-Creme"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":14},{"background":"#f2f2f2","color":"#000000","index":2,"value":76},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":25},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Gumbar Gummibarchen"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":31.23},{"background":"#ffffff","color":"#000000","index":2,"value":15},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":26},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Schoggi Schokolade"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":43.9},{"background":"#f2f2f2","color":"#000000","index":2,"value":49},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":27},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Rossle Sauerkraut"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":45.6},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":26},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":28},{"cells":[{"background":"#ffc7ce","color":"#9c0006","index":0,"value":"Thuringer Rostbratwurst"},{"background":"#ffc7ce","color":"#9c0006","format":"\"$\"#,##0.00","index":1,"value":123.79},{"background":"#ffc7ce","color":"#9c0006","index":2,"value":0},{"background":"#ffc7ce","color":"#9c0006","bold":true,"index":3,"textAlign":"center","value":"Yes"}],"index":29},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Nord-Ost Matjeshering"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":25.89},{"background":"#ffffff","color":"#000000","index":2,"value":10},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":30},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Gorgonzola Telino"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":12.5},{"background":"#f2f2f2","color":"#000000","index":2,"value":0},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":31},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Mascarpone Fabioli"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":32},{"background":"#ffffff","color":"#000000","index":2,"value":9},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":32},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Geitost"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":2.5},{"background":"#f2f2f2","color":"#000000","index":2,"value":112},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":33},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Sasquatch Ale"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":14},{"background":"#ffffff","color":"#000000","index":2,"value":111},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":34},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Steeleye Stout"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":18},{"background":"#f2f2f2","color":"#000000","index":2,"value":20},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":35},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Inlagd Sill"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":19},{"background":"#ffffff","color":"#000000","index":2,"value":112},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":36},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Gravad lax"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":26},{"background":"#f2f2f2","color":"#000000","index":2,"value":11},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":37},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Cote de Blaye"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":263.5},{"background":"#ffffff","color":"#000000","index":2,"value":17},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":38},{"cells":[{"background":"#f2f2f2","color":"#000000","index":0,"value":"Chartreuse verte"},{"background":"#f2f2f2","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":18},{"background":"#f2f2f2","color":"#000000","index":2,"value":69},{"background":"#f2f2f2","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":39},{"cells":[{"background":"#ffffff","color":"#000000","index":0,"value":"Boston Crab Meat"},{"background":"#ffffff","color":"#000000","format":"\"$\"#,##0.00","index":1,"value":18.4},{"background":"#ffffff","color":"#000000","index":2,"value":123},{"background":"#ffffff","color":"#00b050","bold":true,"index":3,"textAlign":"center","value":"No"}],"index":40}],"selection":"C6:C6"}],"toolbar":{"home":true,"insert":true,"data":true}});}); .download { width: 260px; }

Description

This demo shows how to export and import files in the Spreadsheet component on the server using Telerik.Web.Spreadsheet assembly.

Additional Apps

This Spreadsheet example is part of a unique collection of hundreds of ASP.NET MVC demos, with which you can see all Telerik ASP.NET MVC 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 the ThemeBuilder.

ASP.NET MVC Spreadsheet Server Import and Export

Description

Additional Apps

Support & Learning Resources

Additional Resources

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

ASP.NET MVC Spreadsheet Server Import and Export

Description

Additional Apps

Support & Learning Resources

Additional Resources