从数据源导出Excel、Word

这个问题比较郁闷

Click事件

Response.ClearContent();

Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
     //如果是WORD文件
     //Response.AppendHeader("Content-Disposition","attachment;filename=File1.doc"); 

    //安全，避免乱码
     Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");

Response.ContentType = "application/excel";
      //Response.ContentType = "application/ms-word";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvUsers.RenderControl(htw);
      //如果是其他控件或对象导出的形式为：
      //Page.RenderControl(HTW);
     //Page为要导出的对象,当前是Page,如果是DataGrid,DataList等都可以

Response.Write(sw.ToString());

Response.End();

 

如果不写这个重载，将报错：控件放入runat=server 中...

 

public override void VerifyRenderingInServerForm(Control control)

{

}

 

完成！！

详细讲解：

http://blog.csdn.net/ttgzs/archive/2007/11/27/1904685.aspx