导出Datagrid里所有数据到excel

    /// <summary>
    /// 导出Datagrid里所有数据到Office
    /// </summary>
    /// <param name="oGridView">要导出的DataGrid</param>
    /// <param name="oBindDataSet">DataGrid的数据源</param>
    public void ExportDataGridToExcel(GridView oGridView, DataSet oBindDataSet)
    {
        oGridView.AllowPaging = false;   //设置不能分页
        oGridView.DataSource = oBindDataSet.Tables[0].DefaultView;  //重新绑定数据源
        oGridView.DataBind();

        //常规导出方法
        System.IO.StringWriter SW = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter HTW = new System.Web.UI.HtmlTextWriter(SW);
        oGridView.RenderControl(HTW);

        //Page为要导出的对象,当前是Page,如果是DataGrid,DataList等都可以
        Response.Buffer = true;
        Response.Clear();
        Response.ClearContent();
        Response.ClearHeaders();
        Response.ContentType = "application/vnd.ms-excel";
        //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=QueryCustomer.xls");
        //attachment --- 作为附件下载
        //inline --- 在线打开
        //filename如过是中文,则可以用HttpUtility.UrlEncode(fileName,System.Text.Encoding.UTF8)
        //进行进行编码,以解决文件名乱码的问题
        Response.Write(SW.ToString());
        Response.Flush();
        Response.Close();
    }