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

Word/CSV Export



CustomerIDCompany NameContact NameContact TitleAddressPostal Code
 Item 11 to 20 of 91
Page:
of 10 GoPage size:
BSBEVB's BeveragesVictoria AshworthSales RepresentativeFauntleroy CircusEC2 5NT
CACTUCactus Comidas para llevarPatricio SimpsonSales AgentCerrito 3331010
CENTCCentro comercial MoctezumaFrancisco ChangMarketing ManagerSierras de Granada 999305022
CHOPSChop-suey ChineseYang WangOwnerHauptstr. 293012
COMMIComércio MineiroPedro AfonsoSales AssociateAv. dos Lusíadas, 2305432-043
CONSHConsolidated HoldingsElizabeth BrownSales RepresentativeBerkeley Gardens 12 BreweryWX1 6LT
DRACDDrachenblut DelikatessenSven OttliebOrder AdministratorWalserweg 2152066
DUMONDu monde entierJanine LabruneOwner67, rue des Cinquante Otages44000
EASTCEastern ConnectionAnn DevonSales Agent35 King GeorgeWX3 6FW
ERNSHErnst HandelRoland MendelSales ManagerKirchgasse 68010
  • Demo Configurator
This example demonstrates RadGrid's Export to Word / CSV formats. There are two ways to integrate the exporting functionality in RadGrid.
  • Codeless (built-in buttons in the CommandItem) - using the CommandItemSettings
  • Manually using the API - we have both server and client methods that can trigger the export

You can configure the exporting settings for the grid through the RadGrid.ExportSettingssection. Most commonly used settings include:

  • FileName - a string specifying the name (without the extension) of the file that will be created. The file extension is automatically added based on the method that is used
  • ExportOnlyData - determines whether only data will be exported
  • IgnorePaging - specifies whether all records will be exported or merely those on the current page
  • OpenInNewWindow - opens the exported grid in a new instead of the same page
  • UseItemStyles - gives you the ability to apply the item styles to the exported file

Note that the exporting feature of the control works with regular postbacks only. Therefore in this demo the new RadAjaxPanel's "PostBackControls" porperty is used for listing the controls that should be excluded from perfoming ajax requests. This property is available for the RadAjaxManager control also sinse Q1 2016 release.

  • DefaultVB.aspx
  • DefaultVB.aspx.vb
  • scripts.js
  • Styles.css
<%@ Page Language="vb" Inherits="Telerik.GridExamplesVBNET.Exporting.ExportToWordCSV.DefaultVB"CodeFile="DefaultVB.aspx.vb"  %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="qsf" Namespace="Telerik.QuickStart" %>
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
    <link rel="Stylesheet" type="text/css" href="styles.css" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <script type="text/javascript" src="scripts.js"></script>
    <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" PostBackControls="ImageButton1,ImageButton2,ImageButton3" CssClass="demo-container no-bg">
        <asp:ImageButton ID="ImageButton1" ImageUrl="images/file-extension-doc-icon_bigger.png"
            OnClick="Button1_Click" runat="server" CssClass="ImageButtons" />
        <asp:ImageButton ID="ImageButton3" ImageUrl="images/file-extension-docx-icon_bigger.png"
            OnClick="ImageButton3_Click" runat="server" CssClass="ImageButtons" />
        <asp:ImageButton ID="ImageButton2" ImageUrl="images/file-extension-csv-icon_bigger.png"
            OnClick="Button2_Click" runat="server" CssClass="ImageButtons" />
        <br />
        <br />
        <telerik:RadGrid RenderMode="Lightweight" ID="RadGrid1" DataSourceID="SqlDataSource1" AllowSorting="True" Skin="Silk"
            AutoGenerateColumns="false" AllowPaging="True" PageSize="10" runat="server" OnItemCommand="RadGrid1_ItemCommand">
            <ExportSettings HideStructureColumns="true">
            </ExportSettings>
            <MasterTableView Width="100%" CommandItemDisplay="Top">
                <CommandItemSettings ShowExportToWordButton="true" ShowExportToCsvButton="true" ShowAddNewRecordButton="false" ShowRefreshButton="false" />
                <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
                <Columns>
                    <telerik:GridBoundColumn DataField="CustomerID" HeaderText="CustomerID">
                        <HeaderStyle BackColor="#8EDDFF" Font-Bold="true" />
                        <ItemStyle BackColor="#B2F4FF" Font-Italic="true" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="CompanyName" HeaderText="Company Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ContactName" HeaderText="Contact Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ContactTitle" HeaderText="Contact Title">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Address" HeaderText="Address">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="PostalCode" HeaderText="Postal Code">
                    </telerik:GridBoundColumn>
                </Columns>
                <ItemStyle BackColor="#DFDFDF" />
                <HeaderStyle BackColor="#FFFFFF" ForeColor="#767676" />
                <AlternatingItemStyle BackColor="#FFFFFF" />
            </MasterTableView>
        </telerik:RadGrid>
    </telerik:RadAjaxPanel>
    <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        ProviderName="System.Data.SqlClient" SelectCommand="SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode FROM Customers"
        runat="server"></asp:SqlDataSource>
    <qsf:ConfiguratorPanel ID="ConfiguratorPanel2" runat="server">
        <Views>
            <qsf:View>
                <ul class="fb-group">
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox1" Text="Export only data" runat="server"></asp:CheckBox></span>
                    </li>
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox2" Text="Ignore paging (exports all pages)" runat="server"></asp:CheckBox></span>
                    </li>
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox3" Text="Open exported data in new browser window" runat="server"></asp:CheckBox></span>
                    </li>
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox4" Text="Use item styles (Word doc-only)" runat="server"></asp:CheckBox></span>
                    </li>
                </ul>
            </qsf:View>
        </Views>
    </qsf:ConfiguratorPanel>
    </form>
</body>
</html>

Support & Learning Resources

Find Assistance