asp.net 从datagrid导出到world

最新推荐文章于 2025-08-07 14:59:42 发布

CodingSir

最新推荐文章于 2025-08-07 14:59:42 发布

阅读量760

点赞数

CC 4.0 BY-SA版权

文章标签： datagrid asp.net string excel date button

本文链接：https://blog.youkuaiyun.com/educast/article/details/2894987

本文介绍了一个简单的日记列表导出功能实现方法，通过绑定数据源到数据网格视图，并将其转换为Excel文件格式，方便用户下载使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private void dgdiaryListBind()
{
   string strDate1=Date1.SelectDate.ToString();
    string strDate2=Date2.SelectDate.ToString();
    DataTable diCart=(new DiaryBF()).GetDiaryInf(strDate1,strDate2);
    this.dgdiaryList.CurrentPageIndex=0;
    this.dgdiaryList.DataSource=diCart;//指定数据源
    this.dgdiaryList.DataBind();//绑定数据源
   }

   private void Button1_Click(object sender, System.EventArgs e)
   {
    DataTable dt=(DataTable)this.dgdiaryList.DataSource;
    string strExcelName="";
    dgdiaryList.AllowPaging=false;
    dgdiaryList.AllowSorting=false;
    dgdiaryListBind();
    dgExcel2.AllowPaging=false;
    dgExcel2.AllowSorting=false;
    dgExcel2.DataSource=dgdiaryList.DataSource;
    dgExcel2.DataBind();
    dgExcel2.Visible=true;
    //ExportExcel(dgAssetList,strExcelName);//直接导出到Excel表格
    ExportExcel(dgExcel2,strExcelName);//直接导出到Excel表格
    dgExcel2.Visible=false;
   }

   private void ExportExcel(DataGrid dg,string strExcelName)
   {
    dg.AllowPaging=false;
    DataGridToExcelDefault(dg,strExcelName);
    HttpContext.Current.Response.End();
   }
   public static void DataGridToExcelDefault(DataGrid dg,string strExcelName)
   {
    if(strExcelName=="")//如果Excel表格未名称，则默认Excel
    {
     strExcelName="World";
    }
    HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename="+strExcelName+".doc");
    HttpContext.Current.Response.ContentType = "application/vnd.ms-wold";
    HttpContext.Current.Response.Charset = "";
    HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.UTF7;//OZR .Default;
    System.IO.StringWriter tw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
    dg.RenderControl(hw);
    HttpContext.Current.Response.Write(tw.ToString());
    //HttpContext.Current.Response.End();
   }