代碼如下:

protected void Excel_Click(object sender, EventArgs e) 
{ 
Response.Charset = "UTF-8"; 
Response.ClearContent(); 
Response.Clear(); 
Response.ContentEncoding = System.Text.Encoding.UTF8; 
Response.HeaderEncoding = System.Text.Encoding.UTF8; 
Response.AddHeader("content-disposition", "attachment; filename=MyExpress.xls"); 
Response.ContentType = "application/excel"; 
System.IO.StringWriter sw = new System.IO.StringWriter(); 
HtmlTextWriter htw = new HtmlTextWriter(sw); 
// turn off paging 
GridView1.AllowPaging = false; 
dataBind(); 
GridView1.RenderControl(htw); 
Response.Write(sw.ToString()); 
Response.End(); 
// turn the paging on again 
GridView1.AllowPaging = true; 
dataBind(); 
} 

關鍵: 

復制代碼代碼如下:

Response.Charset = "UTF-8";//添加編碼格式 
Response.ClearContent(); 
Response.Clear(); 
Response.ContentEncoding = System.Text.Encoding.UTF8;//表格內容添加編碼格式 
Response.HeaderEncoding = System.Text.Encoding.UTF8;//表頭添加編碼格式 

上邊如果解決不了還可以用 

復制代碼代碼如下:

Response.ClearContent(); 
Response.Clear(); 
Response.AddHeader("content-disposition", "attachment; filename=sumlate.xls"); 
Response.Charset = "GB2312"; 
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); 
Response.ContentType = "application/excel"; 
System.IO.StringWriter sw = new System.IO.StringWriter(); 
HtmlTextWriter htw = new HtmlTextWriter(sw); 
if (GridView2.Rows.Count > 0) 
{ 
GridView2.RenderControl(htw); 
} 
else 
{ 
GridView1.RenderControl(htw); 
} 
Response.Write(sw.ToString()); 
Response.End(); 

關鍵： 

復制代碼代碼如下:

Response.Charset = "GB2312"; 
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); 

注意觀察，主要原因其實就是編碼格式問題。 

現在就能防止導出時候亂碼問題了