[Solved] Master / Details Styling (Excel Export)

[Andy]

Hi,

I have grid control that that has master / detail
setup.  I’m trying to get this to export
to excel (html) but I’m having trouble figuring out how to apply 1 type of
formatting to master data and another type of formatting to child data


So for example this code applies formatting to all rows


        

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    GridDataItem item = e.Cell.Parent as GridDataItem;

    if (item.ItemType == GridItemType.AlternatingItem)
        item.Style["background-color"] = "#359AFF";
    else
        item.Style["background-color"] = "#2D62FF";

}

 Any ideas how I accomplish separate formatting please?

[Konstantin Dikov]

Hello Andy,

For distinguishing the item's table view and determining whether the items is within the MasterTableView or within a DetailTable you could use the Name property of the TableView's and use that name for your condition.

For example, if you set the Name property of your MasterTableView to "MasterTable", you could modify your current code as shown bellow:

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnExportCellFormatting="RadGrid1_ExportCellFormatting">
    <MasterTableView Name="MasterTable" AutoGenerateColumns="false" CommandItemDisplay="Top" CommandItemSettings-ShowExportToExcelButton="true">
    ....

And the code-behind:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    GridDataItem item = e.Cell.Parent as GridDataItem;

    if (item.OwnerTableView.Name == "MasterTable")
    {
        if (item.ItemType == GridItemType.AlternatingItem)
            item.Style["background-color"] = "#359AFF";
        else
            item.Style["background-color"] = "#2D62FF";
    }
    else
    {
        //apply different styles for nested TableViews
    }
}

Hope this helps.
 

Regards,
Konstantin Dikov
Telerik

 

 

[Andy]

Many thanks.