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