Silk skin

Grid - Export Multiple Grids



Order IDOrder DateFreightShip NameShip Country
Page size:
 830 items in 277 pages
102487/4/1996 12:00:00 AM32.38Vins et alcools ChevalierFrance
102497/5/1996 12:00:00 AM11.61Toms SpezialitätenGermany
102507/8/1996 12:00:00 AM65.83Hanari CarnesBrazil

Customer IDContact NameCompany NameContact TitleCountry
Page size:
 91 items in 31 pages
ALFKIMaria AndersAlfreds FutterkisteSales RepresentativeGermany
ANATRAna TrujilloAna Trujillo Emparedados y heladosOwnerMexico
ANTONAntonio MorenoAntonio Moreno TaqueríaOwnerMexico

Product IDProduct NameSupplier IDCategory IDUnit Price
Page size:
 77 items in 26 pages
1Chai1118.00
2Chang1119.00
3Aniseed Syrup1210.00
Isolate this demo as a stand-alone application
  • About this demo
  • C#
  • VB

This is a practical demonstration of the new GenerateXlsxOutput() method provided by the grid. It can be utulized further for different scenarios where you need the Excel XLSX output even without actually exporting anything.

  • DefaultVB.aspx
  • DefaultVB.aspx.vb
<%@ Page Language="vb" AutoEventWireup="false" Inherits="Telerik.GridExamplesCSharp.Exporting.ExportToExcel.DefaultVB"CodeFile="DefaultVB.aspx.vb"  %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Register TagPrefix="qsf" Namespace="Telerik.QuickStart" %>
<!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>
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />
    <telerik:RadButton RenderMode="Lightweight" ID="RadButton1" runat="server" Text="Export All Grids"
        Height="60px" OnClick="RadButton1_Click">
        <Icon PrimaryIconCssClass="rbSave"></Icon>
    </telerik:RadButton>
    <br />
    <br />
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" CellSpacing="0"
        DataSourceID="SqlDataSource1" GridLines="None" PageSize="3"
        OnColumnCreated="RadGrids_ColumnCreated">
        <ExportSettings IgnorePaging="true" ExportOnlyData="true">
            <Excel Format="Xlsx" />
        </ExportSettings>
        <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="OrderID">
        </MasterTableView>
    </telerik:RadGrid>
    <br />
    <telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True" CellSpacing="0"
        DataSourceID="SqlDataSource2" GridLines="None" PageSize="3"
        OnColumnCreated="RadGrids_ColumnCreated">
        <ExportSettings IgnorePaging="true" ExportOnlyData="true">
            <Excel Format="Xlsx" />
        </ExportSettings>
        <MasterTableView DataSourceID="SqlDataSource2" DataKeyNames="CustomerID">
        </MasterTableView>
    </telerik:RadGrid>
    <br />
    <telerik:RadGrid ID="RadGrid3" runat="server" AllowPaging="True" CellSpacing="0"
        DataSourceID="SqlDataSource3" GridLines="None" PageSize="3"
        OnColumnCreated="RadGrids_ColumnCreated">
        <ExportSettings IgnorePaging="true" ExportOnlyData="true">
            <Excel Format="Xlsx" />
        </ExportSettings>
        <MasterTableView DataSourceID="SqlDataSource3" DataKeyNames="ProductID">
        </MasterTableView>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        SelectCommand="SELECT [OrderID], [OrderDate], [Freight], [ShipName], [ShipCountry] FROM [Orders]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        SelectCommand="SELECT [CustomerID], [ContactName], [CompanyName], [ContactTitle], [Country] FROM [Customers]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [UnitPrice] FROM [Products]"></asp:SqlDataSource>
    </form>
</body>
</html>

Find Assistance

Help Us Improve

Was this example helpful?