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
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- 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

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-dropdown { width: 120px; } #configurator .margins .k-numerictextbox { width: 80px; } #configurator .margins label { display: inline-block; width: 50px; } #configurator .actions { clear: left; }

Server Export to PDF

Support & Learning Resources

Was this demo helpful?

Tell us how we can improve this demo