How to Stop Long Numeric to Scientific Conversion if Transfering data from DataGrid to Excel.

[RSB]

Hi Everyone,
i am using the following code to transfer a DataGrid to Excel File.
Every thing works ok beside the long numerice value like 0000121900000000
gets converted to 1.219E+11.
how can i disable that conversion?
Thanks for the Help

RSB



public static void DataGridToExcel(DataGrid dgExport, HttpResponse
response){
response.Clear();
response.Charset = "";
response.ContentType = "application/vnd.ms-excel";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
DataGrid dg = new DataGrid();
dg = dgExport;
dg.AllowPaging = false;
dg.AllowSorting = false;
dg.GridLines = GridLines.Both;
dg.HeaderStyle.Font.Bold = true;
dg.DataBind();
dg.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
response.End();
}

 

[David Jessee]

Well, its not converting....its just a formatting issue. I don't know what
your class is doing as far as exporting the data, so I can't tell you
exactly how to do it. But approach it as a formatting issue

 

[Yavuz Kucukpetek]

You should format your data in order to fake the excel that this value is not numeric. Normally in excel a leading ' character is enough to make the cell in text format ' character should not be seen in the grid.

So you should format the grid column as DataFormatString=" {0}"

I think this helps.