Export columnn value instead of image (excel)

[aykut]

Dear friends,

I have a template column that shows images according to database value:

<ItemTemplate>
    <asp:Image runat="server" AlternateText="" ImageUrl="Images/ColdChain.png" Width="20px"
        Height="20px" Visible='<%#  iif ( SomeFunction(Eval("ColdChain")) ="", "false" , "true") %>' />
</ItemTemplate>

when exporting to excel, I want some text to be exported instead of image itself. For example I need "COLD" text in that column instead of image or image link itself.

how can I achieve this ?
thanks....

[Shinu]

Hello Aykut,

You can try the following code snippet.
C#:

protected void btn_Click(object sender, EventArgs e)
{
    RadGrid1.ExportSettings.ExportOnlyData = true;
    foreach (GridDataItem item in RadGrid1.Items)
    {
     TableCell cell = (TableCell)item["TemplateColumn"];
     cell.Text = "COLD";
    }
    RadGrid1.MasterTableView.ExportToExcel();
}

-Shinu.