DataGrid导出为excel和word

Introduction

DataGrid is one of the most coolest controls in ASP.NET. One thing that all developers need is to put the DataGriddata into an Excel sheet. In this article I will show you how you can export your DataGrid data to an Excel file, a Word file and also a text file.

Exporting DataGrid to Excel

Exporting DataGrid to Excel might sound complex but it's pretty simple. Let's see how this can be done.

 Collapse |  Copy Code

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

Response.Charset = "GB2312";

 if (System.Threading.Thread.CurrentThread.CurrentCulture.Name == "Zh-TW")//判断是简体系统还是繁体系统
            {
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
            }
            else
            {
                Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            }

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWr