asp.net导出ＥＸＣＥＬ

 打开EXCEL模板，赋值到单元格实现EXCEL文件下载

protected void Button1_Click(object sender, EventArgs e)  
  {  
  Export("application/ms-excel", "a.xls");  
  }  

  private void Export(string FileType, string FileName)  
  {  
  Response.Charset = "GB2312";  
  Response.ContentEncoding = System.Text.Encoding.UTF7;  
  Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());  
  Response.ContentType = FileType;  
  this.EnableViewState = false;  
  StringWriter tw = new StringWriter();  
  HtmlTextWriter hw = new HtmlTextWriter(tw);  
  GridView1.RenderControl(hw);  
  Response.Write(tw.ToString());  
  Response.End();  
  }  
  public override void VerifyRenderingInServerForm(Control control)  
  {  
  }  
~