MVC 导出 EXCEL

最新推荐文章于 2022-06-18 16:21:59 发布

正怒月神

最新推荐文章于 2022-06-18 16:21:59 发布

阅读量1.2k

点赞数

分类专栏： mvc 文章标签： mvc

本文链接：https://blog.csdn.net/hanjun0612/article/details/54139014

版权

mvc 专栏收录该内容

49 篇文章 0 订阅

订阅专栏

public ActionResult CreateExcel(EL_ExhibitList entity)
        {
            EL_ExhibitListBLL exl = new EL_ExhibitListBLL();
            var q = exl.FindList<int>()//数据源
                    

            StringBuilder sb = new StringBuilder();
            //这句很重要
            sb.Append("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>");
            sb.Append("<table border='1' cellspacing='1' cellpadding='1'>");
            sb.Append("<tr>");
            sb.Append("<td>Exhibit</td>");
            sb.Append("</tr>");
            foreach (var item in q)
            {
                sb.Append("<tr>");
                sb.Append("<td>" + (item.EL_Exhibit == null ? "" : item.EL_Exhibit.ExhibitNameEN) + "</td>");
                sb.Append("</tr>");
            }
            sb.Append("</table>");
            byte[] fileContents = Encoding.UTF8.GetBytes(sb.ToString());//utf8 防止中文乱码

            return File(fileContents, "application/vnd.ms-excel charset=gb2312;", string.Format("{0}.xls", Guid.NewGuid()));
        }