net后台导出到excel word
来源:互联网 发布:iosapp性能优化 编辑:程序博客网 时间:2024/06/07 14:43
.net导出到Excel与Word中(带上下标) [dv试图导出]
//输出到excel的函数,可直接copy到 cs页面
private void OutExcel(GridView dg, string name)
{
dg.Visible = true;
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
name = "attachment;filename=" + name;
Response.AppendHeader("Content-Disposition", name);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-excel";
dg.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dg.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
//输出到word的函数,可直接copy到 cs页面
private void OutWord(GridView dg, string name)
{
dg.Visible = true;
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
name = "attachment;filename=" + name;
Response.AppendHeader("Content-Disposition", name);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-word";
dg.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dg.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
//重载VerifyRenderingInServerForm方法,调用页面必须加入否则会提示错误
public override void VerifyRenderingInServerForm(Control control)
{
}
//调用方法 OutWord(Student, "File name.doc");
protected void Button1_Click(object sender, EventArgs e)
{
OutWord(Student, "File name.doc");
}
//调用方法 OutExcel(Student, "File name.xls");
protected void Button2_Click(object sender, EventArgs e)
{
OutExcel(Student, "File name.xls");
}
=========================================================
好
利用ASP.NET输出指定内容的WORD、EXCEL、TXT、HTM等类型的文档很容易的。主要分为三步来完成。
一、定义文档类型、字符编码
Response.Clear();
Response.Buffer= true;
Response.Charset="utf-8";
//下面这行很重要, attachment 参数表示作为附件下载,您可以改成 online在线打开
//filename=FileFlow.xls 指定输出文件的名称,注意其扩展名和指定文件类型相符,可以为:.doc || .xls || .txt ||.htm
Response.AppendHeader("Content-Disposition","attachment;filename=FileFlow.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
//Response.ContentType指定文件类型 可以为application/ms-excel || application/ms-word || application/ms-txt || application/ms-html || 或其他浏览器可直接支持文档
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
二、定义一个输入流
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
三、将目标数据绑定到输入流输出
this.RenderControl(oHtmlTextWriter);
//this 表示输出本页,你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件
Response.Write(oStringWriter.ToString());
Response.End();
- net后台导出到excel word
- .NET后台导出EXCEL
- Asp.net GridView数据导出到Excel,Word
- ASP.NET 导出Panel、GridView控件到Excel或Word
- ASP.NET(C#)将数据导出到Word或Excel
- DataTable导出到excel word
- 数据 导出到Word 、excel
- js导出到word excel .
- 导出数据到Excel/Word
- JSP导出到excel,word
- JavaScript导出到word、excel !!!
- asp.net 导出Excel/Word
- .net 导出到Excel
- .NET 导出到excel
- asp.net 导出到word
- DataGrid导出到Word/Excel文档
- GridView数据导出到Word/Excel中
- 页面导出到Excel、Word、txt
- C#的数据类型
- C++ 常考笔试题汇总
- SQL操作全集 (转)
- XML文档定义有几种形式?它们之间有何本质区别?解析XML文档有哪几种方式
- 程序员的十层楼
- net后台导出到excel word
- 从顺溜想到的
- SQL索引
- 查询速度慢的原因很多,常见如下几种
- ifstream获取文件大小
- 省、市联动的SQL脚本
- Painter 11 中文汉化破解版下载及问题解决
- 作业
- Windows 2003下如何安装MSN9