This is a migrated thread and some comments may be shown as answers.

RadGrid ExcelML Export Error

4 Answers 119 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Mohamed Salah Al-Din asked on 29 May 2012, 03:38 PM

before-click.png

after-click.png

i am facing a problem with grid excel export, after clicking export the grid is disappearing and nothing happean

MasterPage:

<telerik:RadScriptManager ID="Main_RadScriptManager" runat="server" />

    <telerik:RadAjaxManager ID="Main_RadAjaxManager" runat="server" >

        <AjaxSettings></AjaxSettings>

        <ClientEvents OnRequestStart="OnRequestStart" />

    </telerik:RadAjaxManager>

    <telerik:RadFormDecorator ID="Main_RadFormDecorator" runat="server" DecoratedControls="All" Skin="Office2007" />

    <telerik:RadStyleSheetManager ID="Main_RadStyleSheetManager" runat="server">

    </telerik:RadStyleSheetManager>

    <telerik:RadCodeBlock ID="Main_RadCodeBlock" runat="server">

        <script type="text/javascript">

            function OnRequestStart(sender, args) {

                if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0) {

                    args.set_enableAjax(false);

                }

            }

        </script>

    </telerik:RadCodeBlock>



    <asp:UpdatePanel ID="Master_UpdatePanel" runat="server" UpdateMode="Conditional" >

        <ContentTemplate>

            <asp:ContentPlaceHolder ID="Popup_ContentPlaceHolder" runat="server" >

            </asp:ContentPlaceHolder>

        </ContentTemplate>

    </asp:UpdatePanel>

ContentPage:

<asp:Content ID="Content2" ContentPlaceHolderID="Popup_ContentPlaceHolder" runat="Server">

<telerik:RadSplitter ID="InnerRadSplitter" runat="server" Height="560px" Width="100%"

Orientation="Horizontal" ResizeMode="AdjacentPane" ResizeWithParentPane="true"

Skin="Vista">

<telerik:RadPane ID="SearchRadPane" runat="server" MaxHeight="150" MinHeight="70"

Scrolling="Y" Width="100%">

<div class="panel message info">

</div>

</telerik:RadPane>

<telerik:RadSplitBar ID="SearchRadSplitBar" runat="server">

</telerik:RadSplitBar>

<telerik:RadPane ID="ResultRadPane" runat="server" Scrolling="None">

<telerik:RadGrid ID="grdData" AllowPaging="false" AllowSorting="false" runat="server"

AutoGenerateColumns="false" Width="100%" Height="100%" Skin="Vista" GridLines="None"

OnItemCreated="grdData_ItemCreated" OnItemCommand="grdData_ItemCommand">

<ClientSettings EnableAlternatingItems="true" EnableRowHoverStyle="true">

<Selecting AllowRowSelect="true" />

<Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true">

</Scrolling>

</ClientSettings>

<ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">

<Excel Format="ExcelML" />

</ExportSettings>

<MasterTableView AutoGenerateColumns="false" Width="100%" CommandItemDisplay="Top">

<NoRecordsTemplate>

<div style="text-align: center; font-weight: bold">

NO_INFO_AVLBL</div>

</NoRecordsTemplate>

<CommandItemTemplate>

<telerik:RadToolBar ID="ReportGenerator_ToolBar" runat="server" Width="100%" EnableRoundedCorners="true"

EnableShadows="true" Skin="Vista" OnButtonClick="ReportGenerator_ToolBar_ButtonClick">

<Items>

<telerik:RadToolBarButton Text="Export" Value="Excel_Export" CommandName="ExportGrid" >

</telerik:RadToolBarButton>

</Items>

</telerik:RadToolBar>

</CommandItemTemplate>

</MasterTableView>

</telerik:RadGrid>

</telerik:RadPane>

<telerik:RadPane ID="FooterRadPane" runat="server" Height="70" Scrolling="None" Width="100%"

Locked="true">

<div class="mainsection buttons-section" style="margin: 5px;">

<asp:Button ID="btn_ReportGeneratorRun" runat="server" Text="Search"

class="button button-blue" OnClick="btn_ReportGeneratorRun_Click" Width="80px" />

</div>

</telerik:RadPane>

</telerik:RadSplitter>

</asp:Content>

ContentPage Code:

protected void grdData_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item.ItemType == GridItemType.CommandItem)

{

RadToolBar ReportGenerator_ToolBar = (RadToolBar)e.Item.FindControl("ReportGenerator_ToolBar");

RadToolBarItem Excel_Export = ReportGenerator_ToolBar.FindItemByValue("Excel_Export");

RadScriptManager.GetCurrent(this.Page).RegisterPostBackControl(Excel_Export);

}

protected void ReportGenerator_ToolBar_ButtonClick(object sender, RadToolBarEventArgs e)

{

string ErrorMessage = "";

try

{

//---------------------------------------

if (e.Item.Value == "Excel_Export")

{

grdData.ExportSettings.FileName = DateTime.Today.ToString("dd.MM.yyyy");

grdData.ExportSettings.IgnorePaging = true;

grdData.ExportSettings.OpenInNewWindow = true;

grdData.MasterTableView.ExportToExcel();

}

//---------------------------------------

}

catch (Exception ex)

{

ErrorMessage += ex.Message;

}

4 Answers, 1 is accepted

answered on 03 Jun 2012, 08:29 AM

gridlayout-beforechanges.png

gridlayout-afterchanges.png

i made some changes

1. add RadAjaxManagerProxy to the ContentPage

<telerik:RadAjaxManagerProxy ID="Email_RadAjaxManagerProxy" runat="server" >
</telerik:RadAjaxManagerProxy>

2. In Page_PreRender Event i Added The Following Code:

protected void Page_PreRender(object sender, EventArgs e)

{

GridCommandItem Email_Command = (GridCommandItem)Email_RadGrid.MasterTableView.GetItems(GridItemType.CommandItem)[0];

RadToolBar Email_ToolBar = Email_Command.FindControl("Email_ToolBar") as RadToolBar;

RadToolBarItem _Export = Email_ToolBar.FindItemByValue("Export");

ImageButton btn_Export = (ImageButton)_Export.FindControl("btn_Export");

RadAjaxManager.GetCurrent(this.Page).AjaxSettings.AddAjaxSetting(btn_Export, Email_RadGrid);

}

now Export is working but with one problem that the grid layout is changed please check the attached image.

i think this change in the grid layout is because the AjaxManagerProxy. specially in this line:

RadAjaxManager.GetCurrent(this.Page).AjaxSettings.AddAjaxSetting(btn_Export, Email_RadGrid);