Hi All,
I have a .aspx page that on Page_Load, DataBinds a GridView from a database. I then export the same page to EXCEL using
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content Disposition", "attachement;filename=Clientes.xls");
Response.Charset = "";
this.EnableViewState = false; [/i]
The Excel page then looks beautiful, but, for example, if one of the columns holds CustomerID like 120004513076 then the EXCEL sheet would transform the column into general format, so the number would appear like 1.20005E+11
Any suggestions? Help is greatly appreciated!