gridview导出excel

 /// <summary>
        /// 导出excel
        /// </summary>
        /// <param name="gv">gridview控件名称</param>
        /// <param name="FileName">要保存的文件名字</param>
        public static void DumpExcel(GridView gv, string FileName)
        {
            string style = @"<style> .text {  } </script>";
            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.Charset = "GB2312";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
            HttpContext.Current.Response.ContentType = "application/excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw); gv.RenderControl(htw);
            // Style is added dynamically
            HttpContext.Current.Response.Write(style);
            HttpContext.Current.Response.Write(sw.ToString());
            HttpContext.Current.Response.End();
        }

样式在gridview里面写好,例如边框是否居中

原文地址:https://www.cnblogs.com/liziqiang/p/3435487.html