将gridView中的数据转换为excel文件

 //输出为xls文件
  protected void Btn_Excel_Click(object sender, EventArgs e)
  {
  string style = @"<style> .text { mso-number-format:/@; } </script> ";
  Response.ClearContent();
  Response.AddHeader("content-disposition", "attachment; filename="+LoginName +".xls");
  Response.ContentType = "application/excel";
  //重新绑定数据,可以保证渠道表头和文件名
  Gv_Report_Bind();
  StringWriter sw = new StringWriter();
  HtmlTextWriter htw = new HtmlTextWriter(sw);
  Gv_Report.RenderControl(htw);
  Response.Write(style);
  Response.Write(sw.ToString());
  Response.End();
  }
  //输出为xls必须override一下VerifyRenderingInServerForm方法(这一点非常重要，否则在点击按钮后会报错，译者注)，代码如下: 
  public override void VerifyRenderingInServerForm(Control control)
  {
  }
  //绑定DataView数据
  protected void Gv_Report_Bind()
  {

  Gv_Data = channelmanager.GetIodDownDegree("channel", DDL_Channel.SelectedValue , LoginName, Txt_StartDate.Value, Txt_EndDate.Value, DDL_Area.SelectedValue , DDL_GateWay.SelectedValue); //得到数据
  Gv_Report.DataSource = Gv_Data;
  Gv_Report.DataBind();
  }