html网页导出Excel表格的方法实现
/// <summary> /// 导出excel /// </summary> /// <param name="FileType">文件类型</param> /// <param name="FileName">文件名称</param> private void Export(string FileType, string FileName) { Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename= " + Server.UrlEncode(FileName)); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = FileType;//设置输出文件类型为excel文件. Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">"); this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH- CN", true); System.IO.StringWriter stringWrite = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.Write(@"<style> .text { mso-number-format:\@; } </script> "); Response.End(); }