如何将数据导入到excel里面

时间:2022-12-18 20:29:25

 如何将数据导入到excel里面

如何将数据导入到excel里面

#region 将数据导入到EXCEL里面的方法
  private void WriteToExcelFromDataGrid(string fileName)
  {
   //导入EXECL
   if(this.DataGrid1.Items.Count==0)
   {
    Response.Write("<script>alert('对不起,你没有查询到任何记录,不能导出数据')</script>");
   }
   else
   {    
    string strFileName="Reports"+fileName+".xls";
    Response.Buffer= false;
    Response.Charset="UTF-7";
    Response.AppendHeader("Content-Disposition","attachment;filename="+strFileName+"");
    Response.ContentEncoding=System.Text.Encoding.GetEncoding("UTF-7");
    //设置输出流为简体中文
    Response.ContentType = "application/vnd.ms-excel";
    //设置输出文件类型为excel文件。
    this.EnableViewState = false;
    System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
    System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
    //this.DataGrid1.RenderControl(oHtmlTextWriter);
    this.RenderChildren(oHtmlTextWriter);
    Response.Write(oStringWriter.ToString());
   
   }
  }
  #endregion