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

Server Export to PDF

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

                        server_side_pdf_export.cshtml
                    
                        Server_Side_Pdf_ExportController.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API

Print

Entire Workbook
Active Sheet
Selection

Paper

Paper Size
Orientation

Margins, cm

Top
Right
Bottom
Left

Options

Center Horizontally
Center Vertically
Print Guidelines

kendo.syncReady(function(){jQuery("#spreadsheet").kendoSpreadsheet({"sheets":[{"name":"Food Order #1","columns":[{"width":100},{"width":215},{"width":115},{"width":115},{"width":115},{"width":155}],"mergedCells":["A1:F1","C15:E15"],"rows":[{"cells":[{"background":"rgb(142,196,65)","color":"white","fontSize":25,"textAlign":"center","value":"My Company - Order #1"}],"height":50},{"cells":[{"background":"rgb(212,223,50)","textAlign":"center","value":"ID"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Product"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Quantity"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Price"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Tax"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Amount"}],"height":25},{"cells":[{"textAlign":"center","value":216321},{"value":"Calzone"},{"textAlign":"center","value":1},{"format":"$#,##0.00","value":12.39},{"format":"$#,##0.00","formula":"C3*D3*0.2"},{"format":"$#,##0.00","formula":"C3*D3+E3"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":546897},{"background":"rgb(234,240,186)","value":"Margarita"},{"background":"rgb(234,240,186)","textAlign":"center","value":2},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":8.79},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C4*D4*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C4*D4+E4"}]},{"cells":[{"textAlign":"center","value":456231},{"value":"Pollo Formaggio"},{"textAlign":"center","value":1},{"format":"$#,##0.00","value":13.99},{"format":"$#,##0.00","formula":"C5*D5*0.2"},{"format":"$#,##0.00","formula":"C5*D5+E5"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":455873},{"background":"rgb(234,240,186)","value":"Greek Salad"},{"background":"rgb(234,240,186)","textAlign":"center","value":1},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":9.49},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C6*D6*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C6*D6+E6"}]},{"cells":[{"textAlign":"center","value":456892},{"value":"Spinach and Blue Cheese"},{"textAlign":"center","value":3},{"format":"$#,##0.00","value":11.49},{"format":"$#,##0.00","formula":"C7*D7*0.2"},{"format":"$#,##0.00","formula":"C7*D7+E7"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":546564},{"background":"rgb(234,240,186)","value":"Rigoletto"},{"background":"rgb(234,240,186)","textAlign":"center","value":1},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":10.99},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C8*D8*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C8*D8+E8"}]},{"cells":[{"textAlign":"center","value":789455},{"value":"Creme Brulee"},{"textAlign":"center","value":5},{"format":"$#,##0.00","value":6.99},{"format":"$#,##0.00","formula":"C9*D9*0.2"},{"format":"$#,##0.00","formula":"C9*D9+E9"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":123002},{"background":"rgb(234,240,186)","value":"Radeberger Beer"},{"background":"rgb(234,240,186)","textAlign":"center","value":4},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":4.99},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C10*D10*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C10*D10+E10"}]},{"cells":[{"textAlign":"center","value":564896},{"value":"Budweiser Beer"},{"textAlign":"center","value":3},{"format":"$#,##0.00","value":4.49},{"format":"$#,##0.00","formula":"C11*D11*0.2"},{"format":"$#,##0.00","formula":"C11*D11+E11"}]},{"cells":[{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)","textAlign":"right"},{"background":"rgb(212,223,50)","format":"$#,##0.00","formula":"SUM(F3:F11)*0.1"}],"index":13},{"cells":[{"background":"rgb(142,196,65)","index":0},{"background":"rgb(142,196,65)","index":1},{"background":"rgb(142,196,65)","color":"white","fontSize":20,"index":2,"textAlign":"right","value":"Total Amount"},{"background":"rgb(142,196,65)","color":"white","format":"$#,##0.00","formula":"SUM(F3:F14)","index":5}],"height":50,"index":14}]},{"name":"Food Order #2","columns":[{"width":100},{"width":215},{"width":115},{"width":115},{"width":115},{"width":155}],"mergedCells":["A1:F1","C15:E15"],"rows":[{"cells":[{"background":"rgb(142,196,65)","color":"white","fontSize":25,"textAlign":"center","value":"My Company - Order #2"}],"height":50},{"cells":[{"background":"rgb(212,223,50)","textAlign":"center","value":"ID"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Product"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Quantity"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Price"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Tax"},{"background":"rgb(212,223,50)","textAlign":"center","value":"Amount"}],"height":25},{"cells":[{"textAlign":"center","value":216321},{"value":"Calzone"},{"textAlign":"center","value":1},{"format":"$#,##0.00","value":12.39},{"format":"$#,##0.00","formula":"C3*D3*0.2"},{"format":"$#,##0.00","formula":"C3*D3+E3"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":546897},{"background":"rgb(234,240,186)","value":"Margarita"},{"background":"rgb(234,240,186)","textAlign":"center","value":2},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":8.79},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C4*D4*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C4*D4+E4"}]},{"cells":[{"textAlign":"center","value":456231},{"value":"Pollo Formaggio"},{"textAlign":"center","value":1},{"format":"$#,##0.00","value":13.99},{"format":"$#,##0.00","formula":"C5*D5*0.2"},{"format":"$#,##0.00","formula":"C5*D5+E5"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":455873},{"background":"rgb(234,240,186)","value":"Greek Salad"},{"background":"rgb(234,240,186)","textAlign":"center","value":1},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":9.49},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C6*D6*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C6*D6+E6"}]},{"cells":[{"textAlign":"center","value":456892},{"value":"Spinach and Blue Cheese"},{"textAlign":"center","value":3},{"format":"$#,##0.00","value":11.49},{"format":"$#,##0.00","formula":"C7*D7*0.2"},{"format":"$#,##0.00","formula":"C7*D7+E7"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":546564},{"background":"rgb(234,240,186)","value":"Rigoletto"},{"background":"rgb(234,240,186)","textAlign":"center","value":1},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":10.99},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C8*D8*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C8*D8+E8"}]},{"cells":[{"textAlign":"center","value":789455},{"value":"Creme Brulee"},{"textAlign":"center","value":5},{"format":"$#,##0.00","value":6.99},{"format":"$#,##0.00","formula":"C9*D9*0.2"},{"format":"$#,##0.00","formula":"C9*D9+E9"}]},{"cells":[{"background":"rgb(234,240,186)","textAlign":"center","value":123002},{"background":"rgb(234,240,186)","value":"Radeberger Beer"},{"background":"rgb(234,240,186)","textAlign":"center","value":4},{"background":"rgb(234,240,186)","format":"$#,##0.00","value":4.99},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C10*D10*0.2"},{"background":"rgb(234,240,186)","format":"$#,##0.00","formula":"C10*D10+E10"}]},{"cells":[{"textAlign":"center","value":564896},{"value":"Budweiser Beer"},{"textAlign":"center","value":3},{"format":"$#,##0.00","value":4.49},{"format":"$#,##0.00","formula":"C11*D11*0.2"},{"format":"$#,##0.00","formula":"C11*D11+E11"}]},{"cells":[{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)"},{"background":"rgb(212,223,50)","textAlign":"right"},{"background":"rgb(212,223,50)","format":"$#,##0.00","formula":"SUM(F3:F11)*0.1"}],"index":13},{"cells":[{"background":"rgb(142,196,65)","index":0},{"background":"rgb(142,196,65)","index":1},{"background":"rgb(142,196,65)","color":"white","fontSize":20,"index":2,"textAlign":"right","value":"Total Amount"},{"background":"rgb(142,196,65)","color":"white","format":"$#,##0.00","formula":"SUM(F3:F14)","index":5}],"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"]}});}); #configurator .paper label { display: inline-block; width: 80px; } #configurator .paper .k-dropdownlist { width: 120px; } #configurator .margins .k-numerictextbox { width: 80px; } #configurator .margins label { display: inline-block; width: 50px; } #configurator .actions { clear: left; }

Description

This demo shows how to export the Spreadsheet's content to PDF on the server using Telerik.Web.Spreadsheet assembly.

Server Export to PDF

Themes & Swatches

Description

Support & Learning Resources