Export to excell file

i want to create a function that would export an excell file according to a dynamically created table in web page..as in same format..please help me

please see my snippet:

GridView1.AllowPaging = true;

StringWriter tw = new StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

HtmlForm frm = new HtmlForm();
string strTmpTime = (System.DateTime.Today).ToString();

if (strTmpTime.IndexOf("/") != -1)
{
strTmpTime = strTmpTime.Replace("/", "-").ToString().Trim();
}
if (strTmpTime.IndexOf(":") != -1)
{
strTmpTime = strTmpTime.Replace(":", "-").ToString().Trim();
}
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=sheet.xls");
Response.Charset = "UTF-8";
EnableViewState = false;
Controls.Add(frm);
frm.Controls.Add(GridView1);
frm.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();

this code gives an error upon opening the excel file:

"The file you are trying to open, [filename], is in a different format than specified by the file extension" error opening Excel files

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhabani Prasad12y ago
HEre am sendind the link in this u can find all ur required details http://forums.asp.net/t/1412788.aspx?How+to+Export+GridView+To+Word+Excel+PDF+CSV+in+ASP+Net
0
Bhabani Prasad12y ago
http://csharp.net-informations.com/excel/csharp-excel-export.htm
0
mary jean ligas12y ago
i dont want to modify my reg edit..is there another solution on this..please give me other article on how to export file in excel
0
Abhay Shanker12y ago
I think It's not an Error it's a warning.you can still able to export the excel file.
For More details check below url

http://support.microsoft.com/kb/948615
0