asp.net(C#) 导出到word excel [100分]

发布网友

我来回答

共2个回答

热心网友

ASP.NET(C#)将数据导出到Word或Excel命名空间:using
System.IO;
using
System.Text;将DataGrid的数据导出到Excel
string
excelname="excel文件名";
HttpContext.Current.Response.Charset
=
"GB2312";
HttpContext.Current.Response.ContentEncoding
=
Encoding.UTF8;
HttpContext.Current.Response.ContentType
=
"application/ms-excel";
HttpContext.Current.Response.AppendHeader("Content-disposition",
"attachment;filename="
+
excelname
+
".xls");
dr1.Page.EnableViewState
=
false;
StringWriter
sw
=
new
StringWriter();
HtmlTextWriter
tw
=
new
HtmlTextWriter(sw);
dr1.RenderControl(tw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
将DataGrid的数据导出到Word
string
excelname="word文件名";
HttpContext.Current.Response.Charset
=
"GB2312";
HttpContext.Current.Response.ContentEncoding
=
Encoding.UTF8;
HttpContext.Current.Response.ContentType
=
"application/ms-winword";
HttpContext.Current.Response.AppendHeader("Content-disposition",
"attachment;filename="
+
excelname
+
".doc");
dr1.Page.EnableViewState
=
false;
StringWriter
sw
=
new
StringWriter();
HtmlTextWriter
tw
=
new
HtmlTextWriter(sw);
dr1.RenderControl(tw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();