Hi All,
I have asp.net code to export data to excel. The code that I have is
protected void ExportToExcel() {
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
gvFiles.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
I have data like this in data Table
Numbers
12345,67898
45678,23456
67890,54326,56734
90877,45455,67896
When I export the data table to excel by using the above code the format is changed to by default General after exporting to excel the data is
1,234,456,789
45,678,234,56
6,789,0543,46
How set the format to Text,in Excel while exporting data using Response object.
Help me through C# code.