C# 表格导出Excel文件

最新推荐文章于 2023-09-27 08:37:46 发布

Captain-G

最新推荐文章于 2023-09-27 08:37:46 发布

阅读量146

点赞数

分类专栏： C# Orchard Core

本文链接：https://blog.csdn.net/G_T_M_E/article/details/111884629

版权

Orchard Core 同时被 2 个专栏收录

16 篇文章 0 订阅

订阅专栏

15 篇文章 0 订阅

订阅专栏

 public FileResult ToFile(string statisticsModuls,int TCount,string Title)
        {
            var sbHtml = new StringBuilder();
            sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>");
            sbHtml.Append("<tr>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>序号</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>姓名</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>班级</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>参赛作品名称</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>学校</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>选送单位(组织机构)</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>联系方式</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>指导老师</td>");
            for (int i = 0; i < TCount; i++)
            {
                sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>评委-{0}</td>",i);
                sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>评分-{0}</td>",i);
            }
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>总分</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>综合得分</td>");
            sbHtml.AppendFormat("<td style='font-family:宋体;font-size:14px;text-align:center;'>备注</td>");

            sbHtml.Append("</tr>");
            List<string> list = new List<string>(statisticsModuls.Split(new string[] { ", " }, StringSplitOptions.RemoveEmptyEntries));
            List<StatisticsModul> staristics = JsonConvert.DeserializeObject<List<StatisticsModul>>(statisticsModuls);
            var index = 0;
            foreach (var p in staristics)
            {
                index++;
                sbHtml.Append("<tr>");
                sbHtml.AppendFormat("<td>{0}</td>", index);
                sbHtml.AppendFormat("<td>{0}</td>", p.MName);
                sbHtml.AppendFormat("<td>{0}</td>", p.ClassLevel);
                sbHtml.AppendFormat("<td>{0}</td>", p.WorkMTitle);
                sbHtml.AppendFormat("<td>{0}</td>", p.SchoolMName);
                sbHtml.AppendFormat("<td>{0}</td>", p.MElectionUnit);
                sbHtml.AppendFormat("<td>{0}</td>", p.TelPhone);
                sbHtml.AppendFormat("<td>{0}</td>", p.InstructorMName);
                foreach (var item in p.TeacherModulList)
                {
                    sbHtml.AppendFormat("<td>{0}</td>", item.TeacherName);
                    sbHtml.AppendFormat("<td>{0}</td>", item.Score);
                }
                sbHtml.AppendFormat("<td>{0}</td>", p.TotalScore);
                sbHtml.AppendFormat("<td>{0}</td>", p.Score);
                sbHtml.AppendFormat("<td style='width: 105px;' ></td>", p.Score);
                sbHtml.Append("</tr>");
            }
            sbHtml.Append("</table>");
            //byte[] fileContents = Encoding.Default.GetBytes(sbHtml.ToString());
            byte[] buffer = Encoding.GetEncoding("UTF-8").GetBytes(sbHtml.ToString());
            return File(buffer, "application/vnd.ms-excel", Title+".xls");
        }