Export to excel, column's format

[Olo]

Hello,
I'm trying export data from grid to excel. It works but a field "bank account" (eg. 12345678901234567890123456) in excel: 1.23E....
So, I don't see account number.
How can I resolve this problem?
My code:

       radgrid.CurrentPageIndex = 0;
        radgrid.ExportSettings.ExportOnlyData = true;
        radgrid.ExportSettings.IgnorePaging = true;
        radgrid.ExportSettings.OpenInNewWindow = true;
        radgrid.ExportSettings.FileName = "Export";

Grid's columns are declarative from xml.

[Princy]

Hello,

You can either try setting the DataFormatString in aspx or in code-behind as shown below:

protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
if (e.Column is GridBoundColumn)
    (e.Column as GridBoundColumn).DataFormatString = " {0} ";
}

or on ItemDataBound like the following:

if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem && isExport)
    foreach (GridTableCell gcell in e.Item.Cells)
        gcell.Text = String.Format(" {0} ", gcell.Text);

Thanks
Princy.

[Bob]

Setting the DataFormatString as specified does not work for me.  Please advise.  Code snippets below.
Thanks

 

 

protected void rgd_ItemCommand(object source, GridCommandEventArgs e)

 

{

 

 

if (e.CommandName == RadGrid.ExportToExcelCommandName)

 

{

isExport =

true;

 

}

 

...
...

 

 

protected void rgd_ItemDataBound(object source, GridItemEventArgs e)

 

{

 

if ((e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem) && isExport)

 

{

 

foreach (GridTableCell gcell in e.Item.Cells)

 

gcell.Text =

String.Format(" {0} ", gcell.Text);

 

}
...
...