将Datagrid导出为Excel

 

public void csExportToExcel(System.Web.UI.WebControls.DataGrid gridDownload,System.Data.DataSet lds, System.Web.HttpResponse Response,Page myPage,string fileName)
        ...{
            gridDownload.DataSource = lds;
            gridDownload.DataBind();

            Response.Clear();
            Response.Buffer = true;
            Response.ContentType="application/vnd.ms-excel";
            Response.AddHeader("Content-disposition", "attachment; filename="+fileName+".xls");
            Response.ContentEncoding=System.Text.Encoding.Default;
            Response.Charset="";
            myPage.EnableViewState = false;
            StringWriter SW = new StringWriter();
            HtmlTextWriter htmlTW = new HtmlTextWriter(SW);
            gridDownload.AllowPaging = false;
            gridDownload.RenderControl(htmlTW);
            Response.Write(SW.ToString());
            Response.End();
        }