PivotGrid - Export to Excel/Word

ExpensesCompany
CountryCityTransportType
Advanced Services AceContinential World CorpDigital CorporateExecutive ImaginationInteractive Key SoftwareInternet Innovation TelecomNetworks Future LlProfit InterworksServer CompuSuperior Outsourcing LLCTechnology Communit GraphicTotal PcUnified Community ExpertsGrand Total
$93,446.40$102,791.04$93,446.40$93,446.40$84,101.76$107,463.36$65,412.48$56,067.84$107,463.36$93,446.40$130,824.96$102,791.04$98,118.72$1,228,820.16
$126,152.64$130,824.96$93,446.40$88,774.08$60,740.16$74,757.12$65,412.48$130,824.96$93,446.40$88,774.08$102,791.04$102,791.04$79,429.44$1,238,164.80
$88,774.08$70,084.80$74,757.12$116,808.00$84,101.76$65,412.48$93,446.40$102,791.04$79,429.44$74,757.12$79,429.44$74,757.12$107,463.36$1,112,012.16
$121,480.32$112,135.68$107,463.36$56,067.84$112,135.68$65,412.48$107,463.36$107,463.36$102,791.04$98,118.72$79,429.44$98,118.72$60,740.16$1,228,820.16
$98,118.72$102,791.04$121,480.32$121,480.32$70,084.80$84,101.76$88,774.08$107,463.36$102,791.04$84,101.76$46,723.20$107,463.36$126,152.64$1,261,526.40
$527,972.16$518,627.52$490,593.60$476,576.64$411,164.16$397,147.20$420,508.80$504,610.56$485,921.28$439,198.08$439,198.08$485,921.28$471,904.32$6,069,343.68
$527,972.16$518,627.52$490,593.60$476,576.64$411,164.16$397,147.20$420,508.80$504,610.56$485,921.28$439,198.08$439,198.08$485,921.28$471,904.32$6,069,343.68
$146,225.76$191,743.68$172,310.40$122,042.04$124,114.08$130,333.92$118,500.60$99,067.32$145,794.24$115,736.64$108,222.24$125,237.52$141,475.32$1,740,803.76
$107,790.72$119,709.60$124,460.04$94,402.44$137,502.36$154,949.16$111,763.68$116,514.12$106,235.76$176,368.92$125,237.52$158,490.60$111,763.68$1,645,188.60
$127,224.00$167,991.48$134,738.40$150,976.20$132,320.40$120,833.04$107,013.24$138,365.40$143,893.32$105,458.28$155,726.64$133,183.44$143,461.80$1,761,185.64
$2,786,144.22$2,816,203.68$2,784,985.44$2,668,372.74$2,679,728.04$2,644,559.16$2,604,262.26$2,658,931.38$2,680,825.44$2,692,009.62$2,667,738.48$2,854,363.44$2,738,126.46$35,276,250.36
Bulgaria SofiaMicrovan
Minivan
Pickup
Truck
Van
Sofia Total
Bulgaria Total
France ParisMicrovan
Minivan
Pickup
Grand Total
Page:
of 7Page size:

Demo Configurator

Isolate this demo as a stand-alone application
  • About this demo
  • C#
  • VB

This is a demonstration of the new Excel export format supported by RadPivotGrid. It is based on a binary XLS (BIFF) format and is supported in all versions of Microsoft Office, starting from 2003.

Here is a brief description of the possible options in the demo's configuration panel above:
  • Disable Paging
    By default the PivotGrid exports only the content of the current visible page. Disable paging to test the export of the whole content of the PivotGrid. This will simply set the RadPivotGrid.ExportSettings.IgnorePaging option.
  • Add a Second Worksheet
    This option shows you how you can use the ExportInfrastructure available in the PivotGridBiffExporting event to provide additional information to your users in subsequent sheets.
  • DefaultCS.aspx
  • DefaultCS.aspx.cs
<%@ Page Language="c#" AutoEventWireup="false" CodeFile="DefaultCS.aspx.cs" Inherits="Telerik.PivotGrid.Examples.AdvancedDataBinding.DefaultCS" %>

<%@ Register TagPrefix="telerik" Namespace="Telerik.QuickStart" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!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:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadPivotGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadPivotGrid1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="ConfiguratorPanel1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="ConfiguratorPanel1"></telerik:AjaxUpdatedControl>
                    <telerik:AjaxUpdatedControl ControlID="RadPivotGrid1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
    </telerik:RadAjaxLoadingPanel>
    <asp:ImageButton ID="Button1" runat="server" ImageUrl="images/Excel_BIFF.png"
        OnClick="ButtonExcel_Click" AlternateText="Biff" />
    <asp:ImageButton ID="Button2" runat="server" ImageUrl="images/Excel_XLSX.png"
        OnClick="ButtonExcel_Click" AlternateText="Xlsx" />
    <asp:ImageButton ID="Button3" runat="server" ImageUrl="Images/Word_DOCX.png"
        OnClick="ButtonWord_Click" AlternateText="Docx" />
    <telerik:RadPivotGrid RenderMode="Lightweight" runat="server" ID="RadPivotGrid1" AllowPaging="true" OnCellDataBound="RadPivotGrid1_CellDataBound"
        OnPivotGridCellExporting="RadPivotGrid1_PivotGridCellExporting"
        OnNeedDataSource="RadPivotGrid1_NeedDataSource" OnPivotGridBiffExporting="RadPivotGrid1_PivotGridBiffExporting"
        AllowSorting="true" AllowFiltering="false" ShowFilterHeaderZone="false">
        <PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true"></PagerStyle>
        <Fields>
            <telerik:PivotGridRowField DataField="Country">
            </telerik:PivotGridRowField>
            <telerik:PivotGridRowField DataField="City">
            </telerik:PivotGridRowField>
            <telerik:PivotGridColumnField DataField="Company">
            </telerik:PivotGridColumnField>
            <telerik:PivotGridRowField DataField="TransportType">
            </telerik:PivotGridRowField>
            <telerik:PivotGridAggregateField DataField="Expenses" DataFormatString="{0:C}" Aggregate="Sum">
            </telerik:PivotGridAggregateField>
        </Fields>
        <ClientSettings EnableFieldsDragDrop="true">
            <Scrolling AllowVerticalScroll="false"></Scrolling>
        </ClientSettings>
    </telerik:RadPivotGrid>
    <telerik:ConfiguratorPanel runat="server" ID="ConfiguratorPanel1">
        <Views>
            <qsf:View>
                <ul class="checkbox-list">
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox1" runat="server" Text="Disable Paging"></asp:CheckBox></span>
                    </li>
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox3" OnCheckedChanged="CheckBox3_CheckedChanged" runat="server"
                                AutoPostBack="true" Checked="true" Text="Export with styles"></asp:CheckBox></span>
                    </li>
                    <li>
                        <span class="checkbox">
                            <asp:CheckBox ID="CheckBox2" runat="server" Text="Add Second Worksheet"></asp:CheckBox></span>
                    </li>
                </ul>
            </qsf:View>
        </Views>
    </telerik:ConfiguratorPanel>
    </form>
</body>
</html>

Find Assistance

Help Us Improve

Was this example helpful?