1.Respone对象及相关的IO介绍
System.IO.StringWriter SW = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter HTW=new System.Web.UI.HtmlTextWriter(SW);
Page.RenderControl(HTW);
//Page为要导出的对象,当前是Page,如果是DataGrid,DataList等都可以
Response.Buffer=true;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "Response.ContentType";
//Response.ContentType是输出流的 HTTP MIME 类型
//Response.ContentType --- word文件
//application/vnd.ms-excel --- excel文件
Response.Charset="utf-8";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
Response.AddHeader("Content-Disposition", "attachment;filename=XXX.doc");
//attachment --- 作为附件下载
//inline --- 在线打开
//filename如过是中文,则可以用HttpUtility.UrlEncode(fileName,System.Text.Encoding.UTF8)进行编码,以解决文件名乱码的问题
Response.Write(SW.ToString());
Response.Flush();
Response.Close();
2.实现方法
列出.net实现导出Word、Exce格式文件调用的具体方法，代码如下：
/// <summary>
/// 将Web控件导出 /// </summary> /// <param name="source">控件实例</param>
/// <param name="type">类型:Excel或Word</param>
public void ExpertControl(System.Web.UI.Control source, DocumentType type) {
//设置Http的头信息,编码格式 if (type == DocumentType.Excel)
{ //Excel Response.AppendHeader("Content-Disposition","attachment;filename=result.xls"); Response.ContentType = "application/ms-excel";
} else if (type == DocumentType.Word) { //Word Response.AppendHeader("Content-Disposition","attachment;filename=result.doc"); Response.ContentType = "application/ms-word"; } Response.Charset = "UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; //关闭控件的视图状态 source.Page.EnableViewState =false; //初始化HtmlWriter System.IO.StringWriter writer = new System.IO.StringWriter() ; System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer); source.RenderControl(htmlWriter); //输出 Response.Write(writer.ToString()); Response.End(); } //文档类型 public enum DocumentType { Word, Excel } 调用方法：
ExpertControl(this, DocumentType.Word);
这是将整个页面导出为Word
//this可以为具体的控件如datagrid/dataList或page表示当前页，DocumentType为导出的文件格式(Excel/word)
注意：当为datagrid或dataList控件时，在导出Excel/word文件时，必须把控件的分页、排序属性去除并重新绑定，否则将出现
"类型“DataGridLinkButton”的控件“DataGrid1__ctl14__ctl1”必须放在具有 runat=server 的窗体标记内。"错误!
3.具体实例
为了让大家具体理解.net实现导出Word、Exce格式文件功能，下面贴出一个具体实例代码以供参考！
前台代码
<%@ Page language="c#" Codebehind="InSum.aspx.cs" AutoEventWireup="false" Inherits="FLX.Portal.InSum" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><HTML> <HEAD> <title>InSum</title> <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" Content="C#"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD> <body> <form id="Form1" method="post" runat="server"> <P> <asp:Label id="Label1" runat="server" Font-Size="14px" Font-Bold="True">输出形式：</asp:Label> <asp:DropDownList id="DDLOutPut" runat="server"> <asp:ListItem Value="Excel">Excel</asp:ListItem> <asp:ListItem Value="Word">Word</asp:ListItem> </asp:DropDownList> <asp:Button id="BtnOutPut" runat="server" Text="导出文件"></asp:Button> <asp:datagrid id="DataGrid1" runat="server" AutoGenerateColumns="False" Width="100%" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="3" AllowPaging="True" Font-Size="12px" ShowFooter="True"> <FooterStyle ForeColor="#000066" BackColor="White"></FooterStyle> <SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#669999"></SelectedItemStyle> <ItemStyle ForeColor="#000066" BorderColor="#D4D0C8"></ItemStyle> <HeaderStyle ForeColor="Black" BackColor="#E1EEFE"></HeaderStyle> <Columns> <asp:BoundColumn DataField="id" HeaderText="id"></asp:BoundColumn> <asp:BoundColumn DataField="count1" HeaderText="count1"></asp:BoundColumn> <asp:BoundColumn DataField="count2" HeaderText="count2"></asp:BoundColumn> <asp:TemplateColumn HeaderText="count3"> <ItemTemplate> <asp:Label id=lblQuantity runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.count3") %>'> </asp:Label> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle HorizontalAlign="Left" ForeColor="#000066" BackColor="White" Mode="NumericPages"></PagerStyle> </asp:datagrid></P> </form> </body></HTML>后台代码
using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;using FLX.Configuration;using System.Text;namespace FLX.Portal{ /// <summary> /// InSum 的摘要说明。 /// </summary> public class InSum : PortalPagePersonal { public int intSum1=0; public int intSum2=0; public int intSum3=0; protected System.Web.UI.WebControls.Button BtnOutPut; protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.DropDownList DDLOutPut; protected System.Web.UI.WebControls.DataGrid DataGrid1; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if(!this.IsPostBack) { this.DataGrid1.DataSource =this.GetDataBind(); this.DataGrid1 .DataBind(); } }
Web 窗体设计器生成的代码 private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { if(e.Item.ItemIndex >= 0)