Silk skin

Spreadsheet - Export to PDF

Note: As of R1 2020 SP1 the export functionality is built-in and supports an easy client-side export to PDF.

  • Home
  • Insert
  • Open...
  • Export...
  • Undo
  • Redo
  • Paste
  • Cut
  • Copy
  • Bold
  • Italic
  • Underline
  • Arial
  • Pick Color(Current Color is blank)
  • Pick Color(Current Color is blank)
  • All borders
    • All borders
    • Inside borders
    • Inside horizontal borders
    • Inside vertical borders
    • Outside borders
    • Left border
    • Top border
    • Right border
    • Bottom border
    • No border
  • Pick Color(Current Color is blank)
  • Horizontal alignment
    • Align Left
    • Align Center
    • Align Right
    • Justify
  • Vertical alignment
    • Align Top
    • Align Middle
    • Align Bottom
  • Wrap text
  • Merge Cells
    • Merge Cells
    • Merge Horizontally
    • Merge Vertically
    • Unmerge
  • Add column left
    • Add column left
    • Add column right
    • Add row above
    • Add row below
  • Delete cells
    • Delete column
    • Delete row
  • Cut
  • Copy
  • Paste
  • Hide
  • Unhide
  • Delete
  • Hide
  • Unhide
  • Delete
Isolate this demo as a stand-alone application
  • About this demo
  • C#
  • VB

The R1 2020 SP1 release introduces the ExportAs dialog that allows the user to export the file to a PDF.

The export to PDF can be triggered programmatically via the API of the underlying Kendo Spreadsheet widget:

  • DefaultVB.aspx
  • DefaultVB.aspx.vb
<%@ Page Language="VB" AutoEventWireup="true" CodeFile="DefaultVB.aspx.vb"  Inherits="Spreadsheet.Examples.Import_Export.DefaultVB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
    <link href="styles.css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
     <qsf:MessageBox ID="MessageBox" Type="Info" Icon="Info" runat="server" Visible="true">
        <p> 
            <b>Note</b>: As of <b>R1 2020 SP1</b> the export functionality is built-in and supports an easy client-side export to PDF.
        </p>
    </qsf:MessageBox>
   
    <div class="demo-container">
        <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1">
            <Toolbar>
                <telerik:SpreadsheetToolbarTab Text="Home">
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Open" ShowLabel="true" />
                        <telerik:SpreadsheetTool Name="ExportAs" ShowLabel="true" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Undo" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="Redo" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Paste" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="Cut" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="Copy" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="Bold" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="Italic" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="Underline" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="FontFamily" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="FontSize" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="BackgroundColor" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="TextColor" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="BorderType" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="BorderColor" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="HorizontalAlignment" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="VerticalAlignment" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="TextWrap" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="MergeCells" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                </telerik:SpreadsheetToolbarTab>
                <telerik:SpreadsheetToolbarTab Text="Insert">
                    <telerik:SpreadsheetToolbarGroup>
                        <telerik:SpreadsheetTool Name="InsertCells" ShowLabel="false" />
                        <telerik:SpreadsheetTool Name="DeleteCells" ShowLabel="false" />
                    </telerik:SpreadsheetToolbarGroup>
                </telerik:SpreadsheetToolbarTab>
            </Toolbar>
        </telerik:RadSpreadsheet>
    </div>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance

Help Us Improve

Was this example helpful?