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

Ignore grouping header when exporting to Excel

16 Answers 1002 Views

Grid

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

Robert LeGood asked on 12 Mar 2008, 02:06 PM

Hi all,

I have a rad grid table where one of the columns is the "Group By" column. When I export to excel, all I want is just the data exported in the order that is presented on the screen, but I get the extra "header" group by lines. IE...

COL1         COL2         COL3
COL1: 12345
12345         xxx               yyy
12345         fygr               dhet
12345         kljasdflk         qweqwe
COL1: 56789
56789         iouoaisuio   oiuiou
56789         werwer         ewrwer

How I can the export to excel to NOT export the group by header lines? I have "ExportOnlyData" set to true.

I tried the following just before the export...

RadGrid1.GroupingEnabled = false;
RadGrid1.Rebind();

...but the rebind changed the order of the rows so that the data was no longer grouped.

Thanks!

16 Answers, 1 is accepted

answered on 17 Mar 2008, 03:01 PM

Hi Robert LeGood,

Try the following:

protected void Button1_Click(object sender, EventArgs e)
    {
        //setup properties for the data export
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        foreach (GridGroupHeaderItem groupItem in     this.RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))
        {
            groupItem.Visible = false;
        }
        RadGrid1.MasterTableView.ExportToExcel();
    }

Hope this helps.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

answered on 09 Aug 2010, 10:44 AM

Ok I got where is the problem exactly but need solution from Telerik support team.

The thing is my group headers are not coming while exporting since I am writing the following code:
if (e.Item is GridGroupHeaderItem)
{
(e.Item as GridGroupHeaderItem).DataCell.Visible = false;
e.Item.PreRender += new EventHandler(Item_PreRender);
}
which is hiding the GroupHeaders DataCell since I need to customize the header as demonstrated in the following link
http://www.telerik.com/help/aspnet-ajax/aligning_items_in_groupheader2.html

Now,Please let me know with (e.Item as GridGroupHeaderItem).DataCell.Visible = false;
and creating my own Table cells for the group header how can I bring the group header while exporting to excel?

answered on 12 Aug 2010, 10:14 AM

shubh.zip

Hello Shubh,

Please download the attached demo and let me know how to modify it so that I can reproduce the problem locally.

Regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 24 Mar 2016, 06:50 PM

Hi,

I am having problem exporting grid data to excel. I am hiding/showing certain columns in radgrid on a dropdown options. That part is done in radGrid_PreRender like this:

radGrid.MasterTableView.GetColumn("Date").Display = false;

Here is my aspx grid definition:

<telerik:RadGrid ID="gridDCCodeAnalysis" runat="server" AutoGenerateColumns="false"
Skin="Office2007" AllowPaging="True" AllowSorting="True" GroupPanelPosition="Top"
PagerStyle-Mode="NextPrevAndNumeric" OnNeedDataSource="gridDCCodeAnalysis_NeedDataSource"
AllowFilteringByColumn="True" FilterItemStyle-Height="10px" ResolvedRenderMode="Classic"
ExportSettings-OpenInNewWindow="true" UseAllDataFields="true"
OnHTMLExporting="gridDCCodeAnalysis_Exporting"
onprerender="gridDCCodeAnalysis_PreRender"
onitemdatabound="gridDCCodeAnalysis_ItemDataBound">
<HeaderStyle Font-Bold="true" HorizontalAlign="Center" Font-Size="Smaller" Font-Names="Verdana" />
<ItemStyle Font-Size="Smaller" />
<AlternatingItemStyle Font-Size="Smaller" />
<ExportSettings OpenInNewWindow="true" ExportOnlyData="true" Excel-Format="Xlsx">
</ExportSettings>

......

</Columns> </Radgrid>

I also have column grouping. When I set excel format to Xlsx, I get a run time error. But, if no option is given or option is ExcelML, no data is exported. Am I missing something ? Any lead would be very helpful. Thanks in advance