switch (e.Item.Value)//parentroot
{
case "2"://Excel
RadMenuItem Excel = e.Item;
foreach (GridDataItem item in RdGridMainpage.Items)
{
string requestid = item["Request ID"].Text.ToString();
if (item.Selected == true)
{
//SendtoMicrOffice(requestid);
this.RdGridMainpage.Columns.FindByUniqueNameSafe("SubjectButton").Visible = false;
this.RdGridMainpage.Columns.FindByUniqueNameSafe("Subjectdata").Visible =true;
}
else
{
item.Visible =
false;
}
}
RdGridMainpage.ExportSettings.ExportOnlyData =
true;
RdGridMainpage.ExportSettings.IgnorePaging =
true;
RdGridMainpage.ExportSettings.OpenInNewWindow =
true;
RdGridMainpage.MasterTableView.ExportToExcel();
break;
and this the source,
<telerik:RadGrid ID="RdGridMainpage" runat="server" AllowPaging="True" AutoGenerateColumns="False" GridLines="None" OnItemCommand="RdGridMainpage_ItemCommand" OnItemDataBound="RdGridMainpage_ItemDataBound" Width="909px" Skin="Vista" AllowMultiRowSelection ="True" OnSelectedIndexChanged="RdGridMainpage_SelectedIndexChanged" OnNeedDataSource="RdGridMainpage_NeedDataSource" >
<MasterTableView DataKeyNames ="fxRequestKey" >
<PagerStyle Mode ="NumericPages" />
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridClientSelectColumn Reorderable="False" UniqueName="ClientSelectColumn" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridClientSelectColumn>
<telerik:GridBoundColumn DataField="fxRequestKey" HeaderText="Request ID" UniqueName="Request ID" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="fcReqCategoryName" HeaderText="Category" UniqueName="Category" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridButtonColumn CommandName="Select" DataTextField="fcSubject" HeaderText="Subject"
UniqueName="SubjectButton" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridButtonColumn>
<telerik:GridBoundColumn Visible ="False" DataField="fcSubject" HeaderText="Subject" UniqueName="SubjectData" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="fcRequestStatusName" HeaderText="Status" UniqueName="Status" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Stage" HeaderText="Stage" UniqueName="Stage" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Initiator" HeaderText="Initiator" UniqueName="Initiator" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Institution" HeaderText="Institution" UniqueName="Institution" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="DATE" HeaderText="Date" UniqueName="Date" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="AGE" HeaderText="Age" UniqueName="Age" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="fxUserKeyOwner" HeaderText="Assign To" UniqueName="Assign To" >
<ItemStyle HorizontalAlign="Left" />
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ExportSettings>
<Pdf PaperSize ="Legal" PageHeight="14in" />
</ExportSettings>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<FilterMenu EnableTheming="True" Skin="Vista">
<CollapseAnimation Duration="200" Type="OutQuint" />
</FilterMenu>
</telerik:RadGrid><br />
sample codes is highly appreciated
thanks