利用HttpResponse将DataTable数据导出为Excel/Word/Txt/Html文档

public static bool DataTableToExcel(System.Data.DataTable dataTable, string fileName)
{
    if (dataTable == null) return false;
    if (string.IsNullOrWhiteSpace(fileName)) return false;

    HttpResponse httpResponse = HttpContext.Current.Response;
    //ContentType 指定文件类型可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 
    httpResponse.ContentType = "application/vnd.ms-excel";
    httpResponse.ContentEncoding = Encoding.UTF8;
    //context.Response.Charset = "GB2312";
    //"attachment"表示作为附件下载，可以改成"online"在线打开。"filename=xxx.xls"指定输出文件名，其扩展名和文件类型相符，可为：.doc  .xls .txt　.html
    httpResponse.AppendHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName, Encoding.UTF8) + ".xls");
    //导出文件 
    System.IO.StringWriter sw = sw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
    //为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid 
    System.Web.UI.WebControls.DataGrid datagrid = datagrid = new System.Web.UI.WebControls.DataGrid();
    datagrid.DataSource = dataTable.DefaultView;
    datagrid.AllowPaging = false;
    datagrid.DataBind();
    //返回客户端 
    datagrid.RenderControl(htw);
    httpResponse.Write(sw.ToString());
    httpResponse.End();

    return true;
}