记下来以备不时只需:
//GvData--界面上的gridview,filename---excel的名字
//“导出excel”按钮的事件里调用下面的方法
public static void ExportExcel(ref GridView GvData, HttpResponse response, string fileName)
{
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GvData.RenderControl(htw);
string strHtml = sw.ToString().Trim();
string ExcelFileName = fileName + DateTime.Now.Date.ToString("yyyyMMddHHmmss") + ".xls";
ExcelHelper.DownloadFile(response, ExcelFileName, strHtml);
}
//下载的方法
public static void DownloadFile(System.Web.HttpResponse response, String FileNameWhenUserDownload, string FileBody)
{
response.ClearHeaders();
response.Clear();
response.Expires = 0;
response.Buffer = true;
//response.AddHeader("Accept-Language", "gb2312");
response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
//文件名称
response.AddHeader("content-disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(FileNameWhenUserDownload, System.Text.Encoding.UTF8).ToString());
response.ContentType = "Application/octet-stream";
//文件内容
response.Write(FileBody);
response.End();
}