.net 导出excel和word

导出Word:  
  private   void   Button13_Click(object   sender,   System.EventArgs   e)  
  {  
  this.Datagrid4.Visible=true;  
  Response.Clear();    
  Response.Buffer=   true;    
  Response.Charset="GB2312";  
  Response.AppendHeader("Content-Disposition","attachment;filename=File1.doc");  
  Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");  
                      Response.ContentType   =   "application/ms-word";  
                      this.Datagrid4.EnableViewState   =   false;  
                      System.IO.StringWriter   oStringWriter   =   new   System.IO.StringWriter();    
                      System.Web.UI.HtmlTextWriter   oHtmlTextWriter   =   new   System.Web.UI.HtmlTextWriter     (oStringWriter);  
  this.Datagrid4.RenderControl(oHtmlTextWriter);    
  Response.Write(oStringWriter.ToString());  
  Response.End();  
  }  
   
  导出Excel:  
  private   void   OutExcel(DataGrid   dg   ,string   name,string   type)  
  {       dg.Visible=true;  
  Response.Clear();    
  Response.Buffer=   true;    
  Response.Charset="GB2312";  
  Response.AppendHeader("Content-Disposition",name);  
  Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");  
  Response.ContentType   =   type;  
  dg.EnableViewState   =   false;  
  System.IO.StringWriter   oStringWriter   =   new   System.IO.StringWriter();    
  System.Web.UI.HtmlTextWriter   oHtmlTextWriter   =   new   System.Web.UI.HtmlTextWriter(oStringWriter);  
  dg.RenderControl(oHtmlTextWriter);    
  Response.Write(oStringWriter.ToString());  
  Response.End();  
  }

 

/////////简单的导入excel方法

调用导出Excel:this.OutExcel(this.Datagrid5,"attachment;filename=File2.xls","application/ms-excel");

 

posted @ 2009-02-18 21:35  学会感恩  阅读(252)  评论(0编辑  收藏  举报