Posted 13 Sep 2012 Link to this post
in my radgrid i have three template columns, first column textbox, second dropdown list, third datecontrol
when i click on export to excel, i need to export the data in Template columns to excel
data
in bound columns are getting exported to excel, problem is only with template columns
can
any one help me how to achieve this Thank you in advance
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
"server"
AutoGenerateColumns
"False"
OnNeedDataSource
"RadGrid1_NeedDataSource"
OnItemCommand
"RadGrid1_ItemCommand"
>
ExportSettings
ExportOnlyData
"true"
</
MasterTableView
DataKeyNames
"ID"
CommandItemDisplay
"Top"
CommandItemSettings
ShowExportToExcelButton
/>
Columns
telerik:GridBoundColumn
DataField
HeaderText
UniqueName
"Name"
telerik:GridTemplateColumn
"FirstName"
ItemTemplate
asp:TextBox
"TextBox1"
></
protected
void
RadGrid1_ItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName == RadGrid.ExportToExcelCommandName)
foreach
(GridDataItem item
in
RadGrid1.MasterTableView.Items)
item[
].Text = (item.FindControl(
)
as
TextBox).Text;
}
RadGrid1_NeedDataSource(
sender, GridNeedDataSourceEventArgs e)
dynamic data =
new
[] {
{ ID = 1, Name =
"aaa"
},
{ ID = 2, Name =
"bbb"
{ ID = 3, Name =
"ccc"
{ ID = 4, Name =
"ddd"
{ ID = 5, Name =
"eee"
};
RadGrid1.DataSource = data;
Posted 26 Nov 2014 in reply to Jayesh Goyani Link to this post
Posted 02 Dec 2014 in reply to Pradip Link to this post
Posted 26 Apr 2016 Link to this post
Hello i am also having a similar issue. I am trying to export a grid with Template column and it is always coming up with "Object reference not set to an instance of an object." error upon clicking the Export to Excel button on the Command Item.
<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" DataSourceID="DivisionDS" GroupPanelPosition="Top" ResolvedRenderMode="Classic" onitemdatabound="RadGrid1_ItemDataBound" onitemcommand="RadGrid1_ItemCommand"> <ExportSettings ExportOnlyData="True" HideStructureColumns="True" IgnorePaging="True" OpenInNewWindow="True"> </ExportSettings> <MasterTableView AutoGenerateColumns="False" DataKeyNames="Division" DataSourceID="DivisionDS" CommandItemDisplay="Top"> <CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True" /> <RowIndicatorColumn Visible="False"> </RowIndicatorColumn> <ExpandCollapseColumn Created="True"> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="Division" FilterControlAltText="Filter Division column" HeaderText="Division" ReadOnly="True" SortExpression="Division" UniqueName="Division"/> <telerik:GridTemplateColumn HeaderText="Department" SortExpression="Department" UniqueName="Department"> <ItemTemplate> <telerik:RadGrid ID="rgDepartment" runat="server" AllowSorting="True" GroupPanelPosition="Top" ResolvedRenderMode="Classic"> <MasterTableView AutoGenerateColumns="False" DataKeyNames="Department"> <Columns> <telerik:GridBoundColumn DataField="Department" FilterControlAltText="Filter Department column" HeaderText="Department" ReadOnly="True" SortExpression="Department" UniqueName="Department"/> <telerik:GridTemplateColumn HeaderText="No Of Guest" SortExpression="GuestNo" UniqueName="GuestNo"> <ItemTemplate> <asp:Label ID="lbGuest" runat="server"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Room Nite" SortExpression="RoomNite" UniqueName="RoomNite"> <ItemTemplate> <asp:Label ID="lbRoomNite" runat="server"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Hotel" SortExpression="Hotel" UniqueName="Hotel"> <ItemTemplate> <telerik:RadGrid ID="rgHotel" runat="server" AllowSorting="True" GroupPanelPosition="Top" ResolvedRenderMode="Classic"> <MasterTableView AutoGenerateColumns="False" DataKeyNames="BookingID"> <Columns> <telerik:GridBoundColumn DataField="BookingID" DataType="System.Int32" FilterControlAltText="Filter BookingID column" HeaderText="BookingID" ReadOnly="True" SortExpression="BookingID" UniqueName="BookingID" Display="false"/> <telerik:GridBoundColumn DataField="HotelID" DataType="System.Int32" FilterControlAltText="Filter HotelID column" HeaderText="HotelID" SortExpression="HotelID" UniqueName="HotelID" Display="false"/> <telerik:GridBoundColumn DataField="Hotel" FilterControlAltText="Filter Hotel column" HeaderText="Hotel" ReadOnly="True" SortExpression="Hotel" UniqueName="Hotel"/> <telerik:GridTemplateColumn HeaderText="Room Nite" SortExpression="HotelRoomNite" UniqueName="HotelRoomNite"> <ItemTemplate> <asp:Label ID="lbHotelRoomNite" runat="server"/> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid>
Posted 28 Apr 2016 Link to this post
RadGrid1.AllowPaging =
false
;
RadGrid1.Rebind();