export data from gridview to msword

ib bellad

12y1.1k.NET

HI
Frnd's.., I had try below showing code to convert data from gridview to msword..but the end data is saved in notepad i need to save in msword..can any1 help..

protected void btn_export_Click(object sender, EventArgs e)

{

GridView1.AllowPaging = false;

GridView1.DataBind();

Response.ClearContent();

Response.AddHeader("content-disposition", string.Format("attachment;filename{0}", "customer.doc"));

Response.Charset = "";

Response.ContentType = "application/ms-word";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

GridView1.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

lab_msg.Text = "data saved";

lab_msg.ForeColor = Color.Green;

}

thank you..

3 Replies

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

Samuel Summers11y ago
What do you mean by "saved in notepad"?
Note that when you call this line: GridView1.RenderControl(htw);
What is done is that a HTML representation of a GridView1 control is written to HtmlTextWriter which uses that StringWriter that you provided him for writing.
So what the "sw" instance actually has is a HTML text, not DOC, but there is a known trick in which if you save a HTML file with a ".doc" extension then MS Word will be able to open it.
If you want a real Word document then you would have to use some other approach.
For example take a look at this C# library for Word documents, it can enable you to convert that HTML content into a Word document with C#.
Alex Smith11y ago
Go through this link

http://www.aspnettutorials.com/tutorials/file/gv-word-aspnet2-csharp/
Riddhi Valecha12y ago
http://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-word/