asp.NetGridView Excelコードへのエクスポート

 
  
StringBuilder sb = new StringBuilder(); 
  
StringWriter sw = new StringWriter(sb); 
  
HtmlTextWriter htw = new HtmlTextWriter(sw); 
  
Page page = new Page(); 
  
HtmlForm form = new HtmlForm(); 
  
GVLinkman.EnableViewState = false; 
  
page.EnableEventValidation = false; 
  
page.DesignerInitialize(); 
  
page.Controls.Add(form); 
  
form.Controls.Add(GVLinkman); 
  
page.RenderControl(htw); 
  
Response.Clear(); 
  
Response.Buffer = true; 
  
Response.ContentType = "application/vnd.ms-excel"; 
  
Response.AddHeader("Content-Disposition", "attachment;filename=data.xls"); 
  
Response.Charset = "UTF-8"; 
  
Response.ContentEncoding = Encoding.Default; 
  
Response.Write(sb.ToString()); 
  
Response.End();