| 标题 | ASP.NET(C#)将数据导出到Word或Excel |
| 内容 | 最简单的方法是把页面上所有的东西都导出 在载入时调用，注意页面里不能有其它控件，包括按钮 void converttoexcel() { Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel"; this.Page.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.Page.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } 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(); ASP.NET 2.0,C#----利用GridView控件导出其他文件(导出Excel，导出Word文件) // 注意，在Visual Studio2005平台下，如果使用GridView导出文件， //就必须重载VerifyRenderingInServerForm方法 public override void VerifyRenderingInServerForm(Control control) { } /// /// 导出到文件的方法， /// /// Model=1:导出为Execl，Model=2:导出为Word private void toFiles(int Model) { string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss"); System.Web.HttpContext HC = System.Web.HttpContext.Current; HC.Response.Clear(); HC.Response.Buffer = true; HC.Response.ContentEncoding = System.Text.Encoding.UTF8;//设置输出流为简体中文 if (Model == 1) { //---导出为Excel文件 HC.Response.AddHeader("Content-Disposition", "attachment;filename=" +HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls"); HC.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 } else { //--- 导出为Word文件 HC.Response.AddHeader("Content-Disposition", "attachment;filename=" +HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc"); HC.Response.ContentType = "application/ms-word";//设置输出文件类型为Word文件。 } System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); this.GridView1.RenderControl(htw); HC.Response.Write(sw.ToString()); HC.Response.End(); } //-导出为Excel文件 protected void ToExecl_Click(object sender, EventArgs e) { toFiles(1); } //-导出为Word文件 protected void Button1_Click(object sender, EventArgs e) { toFiles(2); } FROM:http://hi.baidu.com/jg_%B3%C2/blog/item/4f0edf188851c50135fa41ce.html C#操作Word[转] 导入COM库：Microsoft word 11.0 Object Library. |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。