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

Export to excel in grid is not working

1 Answer 96 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Akki
Top achievements
Rank 1
Akki asked on 22 Feb 2012, 06:00 PM


Hi have included export to excel button in telerik grid. with below code export to excel is not working.. couldn't figure out whats the error
is..Help me out.
below is my code.  
<div>
        <telerik:RadGrid ID="rdGrdBudgetAssignment" runat="server" AllowPaging="true" AutoGenerateColumns="false"
            PageSize="15" GridLines="None" CssClass="radgrid" AllowFilteringByColumn="true"
            Width="100%" Skin="Office2007" OnPageIndexChanged="rdGrdBudgetAssignment_PageIndexChanged"
            OnItemCommand="rdGrdBudgetAssignment_ItemCommand">
            <clientsettings>
                <Scrolling AllowScroll="true" UseStaticHeaders="true" />
            </clientsettings>
            <pagerstyle mode="NextPrevAndNumeric" />
            <exportsettings exportonlydata="false" ignorepaging="true" openinnewwindow="true"
                hidestructurecolumns="true">
            </exportsettings>
            <mastertableview allowpaging="true" allowfilteringbycolumn="true" commanditemdisplay="Top"
                width="100%">
                <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" />
                <CommandItemSettings ExportToExcelText="Export To Excel" ShowExportToExcelButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false" />
               <%-- <CommandItemSettings ExportToExcelText="Export To Excel" ShowExportToExcelButton="true"
                    ShowAddNewRecordButton="false" ShowRefreshButton="false" /> --%>                 
                <Columns>
                    <telerik:GridTemplateColumn HeaderText="Budget ID" UniqueName="BudgetID" DataField="budhdrtky"
                        Visible="true" ReadOnly="true">
                        <ItemTemplate>
                            <asp:LinkButton ID="lnkBtnBudgetId" runat="server" Text='<%#Eval("budhdrtky")%>'></asp:LinkButton>
                        </ItemTemplate>
                        <HeaderStyle Width="130px" />
                        <ItemStyle Width="130px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Product Level" DataField="prdlvldsc" UniqueName="ProductLevelDesc">
                        <HeaderStyle Width="140px" />
                        <ItemStyle Width="140px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderText="Product" DataField="prdgrpcoddsc" UniqueName="Product">
                        <HeaderStyle Width="170px" />
                        <ItemStyle Width="170px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn Visible="true" UniqueName="imgbtnFirst">
                        <ItemTemplate>
                            <asp:ImageButton ID="imgbtnFirst" runat="server" OnClick="btnFirstOnClick" Width="15px"
                                Height="15px" ImageUrl='<%# Eval("stsflg").ToString() =="S" ? "../IMages/MoveDown.gif" :"../IMages/Cancel.gif"%>'
                                ToolTip='<%# Eval("stsflg").ToString() =="S" ? "Reject" :"Cancel"%>' />
                        </ItemTemplate>
                        <HeaderStyle Width="105px" />
                        <ItemStyle Width="105px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn Visible="true">
                       <ItemTemplate>
                            <asp:ImageButton ID="imgbtnSecond" runat="server" OnClick="btnSecondOnClick" Width="15px"
                                Height="15px" ImageUrl='<%# Eval("stsflg").ToString() =="S" ? "../IMages/MoveUp.gif" :"../IMages/Submit.gif"%>'
                                ToolTip='<%# Eval("stsflg").ToString() =="S" ? "Approve" :"Submit for Approval"%>' />
                        </ItemTemplate>
                        <HeaderStyle Width="105px" />
                        <ItemStyle Width="105px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Year Sales" DataField="totsal" ItemStyle-HorizontalAlign="Right">
                        <HeaderStyle Width="140px" />
                        <ItemStyle Width="140px" />
                    </telerik:GridBoundColumn>
                </Columns>
            </mastertableview>
            <clientsettings allowcolumnsreorder="true" reordercolumnsonclient="true">
                <Resizing EnableRealTimeResize="true" AllowColumnResize="true" />
            </clientsettings>
        </telerik:RadGrid>
    </div>

Regards,
Akki

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 23 Feb 2012, 05:07 AM
Hello Akki,

Make sure that you are using Advanced data binding using NeedDataSource event to bind the grid. Check the following help documentation which explains more about this.
Advanced Data-binding (using NeedDataSource event).

-Shinu.
Tags
Grid
Asked by
Akki
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or