How to prevent Excel from converting in C # by scientific calculation

How to prevent Excel from converting in C # by scientific calculation

string style = @ "<style>.text{mso-number-format:\@;} </style> ";//Note that this is a style that does not need to be modified to be used directly

Response.Clear ();
Response.Buffer = true;


Response.Charset = "Utf-8";
Response.appendheader ("Content-disposition", "Attachment;filename=plandetail.xls");
response.contentencoding = System.Text.Encoding.UTF8;
Response.ContentType = "Application/ms-excel";//Set Output file type to excel file.
System.IO.StringWriter ostringwriter = new System.IO.StringWriter ();
System.Web.UI.HtmlTextWriter ohtmltextwriter = new System.Web.UI.HtmlTextWriter (ostringwriter);
This. Gridview2.rendercontrol (Ohtmltextwriter);


Response.Output.Write (style);//It is important here not to write the style in the file.


Response.Output.Write (Ostringwriter.tostring ());
Response.Flush ();
Response.End ();

How to prevent Excel from converting in C # by scientific calculation