Rank 1
Bronze
Iron
Hello
Attacted File : problem1.png, problem2.xlsx, problem3.png
Can't save excel in Radgrid.
If you look at the attached file(Problem1.png), there is a GridColumnGroup-Header.
However, the GridColumnGroup-Header does not appear in this Excel attached file (Problem3.png).
protected void ibtnExcel_Click(object sender, ImageClickEventArgs e)
{
ConfigureExport();
gv.MasterTableView.ExportToExcel();
}
private void ConfigureExport()
{
if (gv == null)
throw new ArgumentNullException("gv");
string fileName = DateTime.Now.ToShortDateString();
//Export settings
gv.ExportSettings.HideStructureColumns = false;
gv.ExportSettings.SuppressColumnDataFormatStrings = false;
gv.ExportSettings.ExportOnlyData = true;
gv.ExportSettings.IgnorePaging = true;
gv.ExportSettings.OpenInNewWindow = true;
gv.ExportSettings.FileName = fileName.Replace("-", "").ToString();
//Excel Format
gv.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
//SetExportFileName(radGrid);
}
<telerik:radgrid id="gv" runat="server" allowpaging="true" allowsorting="true" enableembeddedskins="false" height="610px"
cellspacing="0" autogeneratecolumns="false" gridlines="Both" pagesize="100" onneeddatasource="gv_NeedDataSource" onexcelexportcellformatting="gv_ExcelExportCellFormatting">
<ClientSettings>
<Selecting AllowRowSelect="True" />
<Resizing AllowColumnResize="True" AllowRowResize="false" ResizeGridOnColumnResize="false" ClipCellContentOnResize="true" EnableRealTimeResize="false" AllowResizeToFit="false" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" FrozenColumnsCount="4"></Scrolling>
</ClientSettings>
<MasterTableView AlternatingItemStyle-Wrap="true" EnableNoRecordsTemplate="true" ShowHeader="true" ShowHeadersWhenNoRecords="true" Width="100%" ItemStyle-Wrap="false" HeaderStyle-Wrap="false" HeaderStyle-Font-Bold="true" TableLayout="Fixed">
<ColumnGroups>
<telerik:GridColumnGroup HeaderText="D+1" Name="D1" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+2" Name="D2" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+3" Name="D3" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+4" Name="D4" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+5" Name="D5" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+6" Name="D6" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+7" Name="D7" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+8" Name="D8" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="D+9" Name="D9" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="08~10" Name="T1" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="10~12" Name="T2" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="13~15" Name="T3" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="15~17" Name="T4" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="17~19" Name="T5" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="20~22" Name="T6" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="22~24" Name="T7" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="01~03" Name="T8" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="03~05" Name="T9" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
<telerik:GridColumnGroup HeaderText="05~07" Name="T10" HeaderStyle-HorizontalAlign="Center" ParentGroupName="D0"></telerik:GridColumnGroup>
</ColumnGroups>
<Columns>
<telerik:GridBoundColumn DataField="ALC_CODE" HeaderText="ALC" Visible="true">
<HeaderStyle Width="100px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemStyle Width="100px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1_2_TOTAL" HeaderText="D+1<br>(1~2T)" Visible="true">
<HeaderStyle Width="60px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemStyle Width="60px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1_6_TOTAL" HeaderText="D+1<br>(3~6T)" Visible="true">
<HeaderStyle Width="60px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemStyle Width="60px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0_PLAN" HeaderText="금일계획" Visible="true">
<HeaderStyle Width="60px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" />
<ItemStyle Width="60px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T01" HeaderText="1T" Visible="true" ColumnGroupName="T1">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T02" HeaderText="2T" Visible="true" ColumnGroupName="T2">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T03" HeaderText="3T" Visible="true" ColumnGroupName="T3">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T04" HeaderText="4T" Visible="true" ColumnGroupName="T4">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T05" HeaderText="5T" Visible="true" ColumnGroupName="T5">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T06" HeaderText="6T" Visible="true" ColumnGroupName="T6">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T07" HeaderText="7T" Visible="true" ColumnGroupName="T7">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T08" HeaderText="8T" Visible="true" ColumnGroupName="T8">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T09" HeaderText="9T" Visible="true" ColumnGroupName="T9">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D0T10" HeaderText="10T" Visible="true" ColumnGroupName="T10">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T01" HeaderText="1T" Visible="true" ColumnGroupName="D1T1">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T02" HeaderText="2T" Visible="true" ColumnGroupName="D1T2">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T03" HeaderText="3T" Visible="true" ColumnGroupName="D1T3">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T04" HeaderText="4T" Visible="true" ColumnGroupName="D1T4">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T05" HeaderText="5T" Visible="true" ColumnGroupName="D1T5">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T06" HeaderText="6T" Visible="true" ColumnGroupName="D1T6">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T07" HeaderText="7T" Visible="true" ColumnGroupName="D1T7">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T08" HeaderText="8T" Visible="true" ColumnGroupName="D1T8">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T09" HeaderText="9T" Visible="true" ColumnGroupName="D1T9">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D1T10" HeaderText="10T" Visible="true" ColumnGroupName="D1T10">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="D4T10" HeaderText="10T" Visible="true" ColumnGroupName="D4T10">
<HeaderStyle Width="65px" CssClass="main_column_header2" HorizontalAlign="Center" VerticalAlign="Middle" Font-Size="11px"/>
<ItemStyle Width="65px" CssClass="rgAltRow" HorizontalAlign="Center" VerticalAlign="Middle" Height="22px" BackColor="White" />
</telerik:GridBoundColumn>
</Columns>
<PagerStyle AlwaysVisible="true" PageSizeControlType="RadDropDownList" PageSizes="20,50,100,200 " FirstPageImageUrl="../../image/list_paging_v1.gif" PrevPageImageUrl="../../image/list_paging_v2.gif" NextPageImageUrl="../../image/list_paging_v3.gif" LastPageImageUrl="../../image/list_paging_v4.gif"></PagerStyle>
<NoRecordsTemplate>
<div style="text-align: center; height: 35px;padding-top:20px;">
</div>
</NoRecordsTemplate>
</MasterTableView>
</telerik:radgrid>
1 Answer, 1 is accepted
Hi Anna,
I am afraid that exporting Multi-column headers (ColumnGroup - header) is not possible with the ExcelML export format.
What you can do is to use another Excel export format - Html, Biff, and Xlsx formats all support the multicolumn headers export to Excel.
You can find more information on this matter in the following public feature request - ADD: RadGrid ExcelML format to support Multi-Column headers feature. In Peter's comment below you will find why exporting multi-column headers is not supported with ExcelML format and more information about the alternatives in front.
I hope you will find this information helpful.
Kind regards,
Doncho
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.