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

[Solved] Radgrid export to excel

5 Answers 335 Views

Grid

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

5 Answers, 1 is accepted

answered on 26 Apr 2013, 07:00 AM

Hi,

I guess you want to hide a column from the excel. Please take a look into the following code snippet.

C#:

protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExportToExcelCommandName)

{

RadGrid1.MasterTableView.GetColumn("ColumnUniqueName").Visible = false;

}

Please check this help documentation for more help. Provide your code if it doesn't help.

Thanks,
Princy.

answered on 26 Apr 2013, 07:20 AM

Hi Princy,

I think it's not a column on the excel but the column header which I think is automatically created for my main grid (holder or 3 grids).
Below is an excerpt on my aspx page. Basically, I have a main dummy grid which will hold the 3 grids need to be exported to excel.

<telerik:RadGrid ID="grdIncidentExcel" runat="server" ShowHeader="false"

GridLines="None" ShowStatusBar="true" OnNeedDataSource="grdIncidentExcel_NeedDataSource"

AllowPaging="false">

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

<Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" FileExtension="CSV" EncloseDataWithQuotes="true" />

<Excel Format="Html" />

</ExportSettings>

<MasterTableView AutoGenerateColumns="true" Width="100%" ShowHeader="false">

<ItemTemplate>

<%--<span style="text-align: left;">Pending Action Owners--%>

<telerik:RadGrid ID="grdPendingActionExcel" runat="server"

GridLines="None" ShowStatusBar="true"

AllowPaging="false"

OnNeedDataSource="grdPendingActionExcel_NeedDataSource"

OnItemDataBound="grdPendingActionExcel_ItemDataBound">

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

<Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" FileExtension="CSV" EncloseDataWithQuotes="true" />

<Excel Format="Html" />

</ExportSettings>

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

<Columns>

<telerik:GridBoundColumn DataField="DisplayModule" HeaderText="Module" ItemStyle-Width="5%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn HeaderText="Action Status" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top">

<ItemTemplate>Pending Action Owner</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="DisplayIncidentNoTask" HeaderText="Incident #" UniqueName="DisplayIncidentNoTask" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn ItemStyle-Width="25%" HeaderText="What" SortExpression="WhatIs" UniqueName="WhatIs" ItemStyle-VerticalAlign="Top">

<ItemTemplate>

<asp:Label ID="lblWhat" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="DisplayGridWhenIsDate" HeaderText="When" UniqueName="WhenIs" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayActionOwnersTask" HeaderText="Who" ItemStyle-Width="20%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="OverdueDays" HeaderText="Overdue (Days)" ItemStyle-Width="5%" UniqueName="OverdueDays" ItemStyle-VerticalAlign="Top" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

<br />

<%--<span style="text-align: left;">Pending Incident Owners--%>

<telerik:RadGrid ID="grdPendingOwnerExcel" runat="server"

GridLines="None" ShowStatusBar="true"

OnNeedDataSource="grdPendingOwnerExcel_NeedDataSource"

OnItemDataBound="grdPendingOwnerExcel_ItemDataBound">

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

<Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" FileExtension="CSV" EncloseDataWithQuotes="true" />

<Excel Format="Html" />

</ExportSettings>

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

<Columns>

<telerik:GridBoundColumn DataField="DisplayModule" HeaderText="Module" ItemStyle-Width="5%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn HeaderText="Action Status" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top">

<ItemTemplate>Pending Incident Owner</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="IncidentNo" HeaderText="Incident #" UniqueName="IncidentNo" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn ItemStyle-Width="20%" HeaderText="Title" UniqueName="Title" ItemStyle-VerticalAlign="Top">

<ItemTemplate>

<asp:Label ID="lblTitle" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="DisplayIncidentType" HeaderText="Incident Type" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayFailureCategory" HeaderText="Failure Category" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayIncidentOwners" HeaderText="Incident Owners" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayGridCreatedDate" HeaderText="Logged Date" UniqueName="CreatedDate" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

<br />

<%--<span style="text-align: left;">Pending Originators--%>

<telerik:RadGrid ID="grdPendingOriginatorExcel" runat="server"

GridLines="None" ShowStatusBar="true"

OnNeedDataSource="grdPendingOriginatorExcel_NeedDataSource"

OnItemDataBound="grdPendingOriginatorExcel_ItemDataBound">

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

<Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" FileExtension="CSV" EncloseDataWithQuotes="true" />

<Excel Format="Html" />

</ExportSettings>

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

<Columns>

<telerik:GridBoundColumn DataField="DisplayModule" HeaderText="Module" ItemStyle-Width="5%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn HeaderText="Action Status" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top">

<ItemTemplate>Pending Originator</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="IncidentNo" HeaderText="Incident #" UniqueName="IncidentNo" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridTemplateColumn ItemStyle-Width="20%" HeaderText="Title" UniqueName="Title" ItemStyle-VerticalAlign="Top">

<ItemTemplate>

<asp:Label ID="lblTitle" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="DisplayIncidentType" HeaderText="Incident Type" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayFailureCategory" HeaderText="Failure Category" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayOriginator" HeaderText="Originator" ItemStyle-Width="15%" ItemStyle-VerticalAlign="Top" />

<telerik:GridBoundColumn DataField="DisplayGridCreatedDate" HeaderText="Logged Date" UniqueName="CreatedDate" ItemStyle-Width="10%" ItemStyle-VerticalAlign="Top" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

</ItemTemplate>

</MasterTableView>

</telerik:RadGrid>

Then my main grid has below code for the datasource:

protected void grdIncidentExcel_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

grdIncidentExcel.DataSource = new string[] { " " };

}

Thanks.

Accepted

answered on 01 May 2013, 07:56 AM

Hello Jayzle,

A possible solution is to hook OnItemDataBound event handler and hide the header item. Check out the following code snippet:

protected void grdIncidentExcel_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridHeaderItem)

{

e.Item.Visible = false;

}

I hope this information helps.

Kind regards,
Kostadin
the Telerik team

If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.