Excel Export formatting for Templated Columns

[Darek]

How does one control Excel cell formatting for a templated column based on a value? The documentation states that one can use

double.Parse(e.Cell.Text) < 0

but Cell.Text is empty for a GridTemplateColumn ...

[Shinu]

Hello Darek,

One suggestion is to access the control in the TemplateColumn and access the value. Here is the sample code.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)

{

    GridDataItem item = e.Cell.Parent as GridDataItem;

    if (e.FormattedColumn.UniqueName == "MyColumn"  )

    {

         TextBox txt = (TextBox)item["MyColumn"].FindControl("Txt1");

         string str = item["MyColumn"].Text;

         if (txt.Text == "Welcome")

        { 


        }

     }

}

Thanks,
Shinu.