ExportToExcel with RadComboBox in RadGrid rows

[Mosart]

Hello Support,

I have a RadGrid that manually exports to Excel via ItemCommand (RadGrid1.MasterTableView.ExportToExcel()). The RadGrid has a RadComboBox in every row. When I export (using ExportOnlyData = True), the RadComboBox columns are ignored and do not show in the exported Excel file.

How do you suggest to print each combo SelectedText to the excel sheet? In which event shoudl I handle it?

Thanks for your help.
Mosart

[Princy]

Hi Mosart,

I created a sample code based on your scenario. Please test it and see if it helps.

ASPX:

<telerik:RadGrid ID="radgrid1" runat="server" DataSourceID="SqlDataSource1" OnItemCommand="radgrid1_ItemCommand"
            OnItemDataBound="radgrid1_ItemDataBound">
            <ExportSettings ExportOnlyData="false" Excel-Format="Html" />
            <MasterTableView CommandItemDisplay="Top">
                <CommandItemSettings ShowExportToExcelButton="true" />
                <Columns>
                    <telerik:GridTemplateColumn HeaderText="test" UniqueName="TempCol">
                        <ItemTemplate>
                            <telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource1"
                                DataTextField="CategoryID" DataValueField="CategoryID" SelectedValue='<%# Eval("CategoryID") %>'>
                            </telerik:RadComboBox>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]" />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]" />

C#:

bool isExport = false;
protected void radgrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName.Contains("Export"))
        {
            isExport = true;
            if (!radgrid1.ExportSettings.IgnorePaging)
            {
                radgrid1.Rebind();
            }
        }
    }
protected void radgrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (isExport)
        {
            if (e.Item is GridDataItem)
            {
                GridDataItem item = e.Item as GridDataItem;

                item["TempCol"].Text = GetCellContents(item["TempCol"]);
            }

            if (e.Item is GridCommandItem)
            {
                e.Item.Visible = false;
            }
        }
    }
private string GetCellContents(TableCell tableCell)
    {
        string cellText = String.Empty;
        foreach (Control ctrl in tableCell.Controls)
        {
            if (ctrl is ITextControl)
            {
                if (ctrl is RadComboBox)
                {
                    cellText += (ctrl as RadComboBox).SelectedItem.Text;
                }
                else
                {
                    cellText += (ctrl as ITextControl).Text;
                }
            }
        }
        return cellText.Replace(" ", " ").Trim();
    }

Thanks,
princy.