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

Excel export of RadGrid not working when grouped by a column

6 Answers 624 Views

Grid

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

Prasanth asked on 09 Apr 2015, 07:19 AM

Hi,

I am using a Radgrid which have footer and groupfooter. But the excel export of the Radgrid is not working properly when it is grouped.

The code which I used to export to Excel is below.

private void lnkExport_Click(object sender, System.EventArgs e)
  {

            uwgAllocationCount.ExportSettings.FileName = "CountSummary " ;
            uwgAllocationCount.ExportSettings.IgnorePaging = true;
            uwgAllocationCount.ExportSettings.OpenInNewWindow = true;
            uwgAllocationCount.MasterTableView.UseAllDataFields = true;
            uwgAllocationCount.ExportSettings.ExportOnlyData = true;
            uwgAllocationCount.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;
            uwgAllocationCount.ExportSettings.HideStructureColumns = false;
            uwgAllocationCount.MasterTableView.HierarchyDefaultExpanded = true;
            uwgAllocationCount.ExportSettings.SuppressColumnDataFormatStrings = false;
            uwgAllocationCount.MasterTableView.ExportToExcel();
  }

I have even tried GridExcelExportFormat.HTML, insted of GridExcelExportFormat.Biff, but it is showing only the grouped headers. It is not exporting the grouped data.

Please help.

Thanks

Prasanth

6 Answers, 1 is accepted

answered on 13 Apr 2015, 06:17 AM

Hi Daniel,

My problem is when i group the RadGrid with a column and then export it to excel, the data is not appearing in the excel sheet. I have tried both Biff and HTML export styles. The code used to export is already given above.

Below is my Radgrid HTML code

<telerik:RadGrid id="rgAllocationCount" runat ="server" AllowPaging="false" AllowSorting="True" OnItemDataBound="rgAllocationCount_ItemDataBound"
GridLines="None" ShowGroupPanel="True" OnNeedDataSource="rgAllocationCount_NeedDataSource" height="550px" MasterTableView-AllowSorting="true" OnBiffExporting="rgAllocationCount_BiffExporting">
<GroupHeaderItemStyle BackColor="navy" ForeColor="white" />
<GroupPanel PanelItemsStyle-Font-Bold="true" PanelItemsStyle-ForeColor="White"></GroupPanel>
<ClientSettings AllowDragToGroup="True" Scrolling-AllowScroll="true"></ClientSettings>
<MasterTableView AutoGenerateColumns ="false" HeaderStyle-ForeColor="White"
ItemStyle-CssClass="Row1" AlternatingItemStyle-CssClass="Row2" GroupsDefaultExpanded="false" Width="100%" ShowFooter="true" FooterStyle-CssClass="FtrRow" ShowGroupFooter="true">
<FooterStyle BorderStyle="Solid" BorderColor="White" BackColor="LightGray" />
<ItemStyle BackColor="#FAF0E6" Font-Names="Tahoma,Verdana" Font-Size="8pt" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px"/>
<HeaderStyle Font-Bold="true" BackColor="Navy" ForeColor="White" />
<AlternatingItemStyle BackColor="#C5CADB" Font-Names="Tahoma,Verdana" Font-Size="8pt" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px"/>
<Columns>
<telerik:GridBoundColumn UniqueName="Instrument" HeaderText="Instrument" SortExpression="Instrument" DataField="Instrument">
<HeaderStyle Width="100px" />
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="SubInstrument" HeaderText="Sub-Instrument" SortExpression="SubInstrument" DataField="SubInstrument">
<HeaderStyle Width="100px" />
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="Status" HeaderText="Status" SortExpression="Status" DataField="Status" EmptyDataText="-">
<HeaderStyle Width="130px" />
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn UniqueName="Type" HeaderText="Type" SortExpression="Type" DataField="Type" EmptyDataText="-">
<HeaderStyle Width="80px" />
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
</telerik:GridBoundColumn>
<telerik:GridNumericColumn Aggregate="Sum" DataField="NumTrans" HeaderText="Num. Trans." DataFormatString="{0:###,###,##0.00}"
SortExpression="NumTrans" UniqueName="NumTrans" FooterText ="Total:= " EmptyDataText="-">
<FooterStyle ForeColor="White" Font-Size="8pt" Font-Bold="true" Font-Names="Tahoma" />
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
</telerik:GridNumericColumn>
<telerik:GridNumericColumn Aggregate="Sum" DataField="NumAlloc" HeaderText="Num. Alloc" DataFormatString="{0:###,###,##0.00}"
SortExpression="NumAlloc" UniqueName="NumAlloc" FooterText ="Total:= " EmptyDataText="-">
<ItemStyle BorderStyle="Solid" BorderWidth="1px"/>
<FooterStyle ForeColor="White" Font-Size="8pt" Font-Bold="true" Font-Names="Tahoma" />
</telerik:GridNumericColumn>

</Columns>
</MasterTableView>
</telerik:RadGrid>

answered on 13 Apr 2015, 03:22 PM

Prasanth.zip

Hello Prasanth,

I have created a runnable demo for you. It is attached to this forum post. Please test it at your side and then let me know whether it behaves as expected when you run it.
The only obvious change I made compared to your code is the following line (added):

protected void lnkExport_Click(object sender, System.EventArgs e)

{

rgAllocationCount.ExportSettings.FileName = "CountSummary ";

rgAllocationCount.ExportSettings.IgnorePaging = true;

rgAllocationCount.ExportSettings.OpenInNewWindow = true;

rgAllocationCount.MasterTableView.UseAllDataFields = true;

rgAllocationCount.ExportSettings.ExportOnlyData = true;

rgAllocationCount.ExportSettings.Excel.Format = GridExcelExportFormat.Html;

rgAllocationCount.ExportSettings.HideStructureColumns = false;

rgAllocationCount.MasterTableView.HierarchyDefaultExpanded = true;

rgAllocationCount.ExportSettings.SuppressColumnDataFormatStrings = false;

rgAllocationCount.MasterTableView.GroupsDefaultExpanded = true;

rgAllocationCount.MasterTableView.ExportToExcel();

}

Regards,
Daniel
Telerik

See What's Next in App Development. Register for TelerikNEXT.