public ActionResult ExportStudentResult(Guid?key) { if (key == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Lecture lecture = _lectureService.GetLecture((Guid)key); if (lecture == null) { return(HttpNotFound()); } ResultHelper resultHelper = new ResultHelper(); IEnumerable <ExportResult_View> results = resultHelper.ExportGetByLecture(lecture); var 學生列表 = results.Select(d => new { d.Employee_ID, d.Compeny, d.Student_Name, Gender = (GenderEnum)d.Gender, d.Birthday, d.Email, d.Phone_Number, d.Goal_Name, d.D, d.I, d.S, d.C, d.Ability, d.Horizontal_Score, d.Vertical_Score, d.T1_Name, d.T2_Name, d.T3_Name }); XLWorkbook 活頁簿 = new XLWorkbook(); IXLWorksheet 工作表1 = 活頁簿.Worksheets.Add("自訂工作表名稱"); 工作表1.Cell(1, 1).Value = "學號"; 工作表1.Cell(1, 2).Value = "系所"; 工作表1.Cell(1, 3).Value = "姓名"; 工作表1.Cell(1, 4).Value = "性別"; 工作表1.Cell(1, 5).Value = "生日"; 工作表1.Cell(1, 6).Value = "電子信箱"; 工作表1.Cell(1, 7).Value = "手機"; 工作表1.Cell(1, 8).Value = "圓夢新思維工作首要條件"; 工作表1.Cell(1, 9).Value = "D"; 工作表1.Cell(1, 10).Value = "I"; 工作表1.Cell(1, 11).Value = "S"; 工作表1.Cell(1, 12).Value = "C"; 工作表1.Cell(1, 13).Value = "業務能力"; 工作表1.Cell(1, 14).Value = "橫座標"; 工作表1.Cell(1, 15).Value = "縱座標"; 工作表1.Cell(1, 16).Value = "最重要"; 工作表1.Cell(1, 17).Value = "次重要"; 工作表1.Cell(1, 18).Value = "重要"; 工作表1.Cell(2, 1).InsertData(學生列表); string FileName = "StudentResult.xlsx"; string FileUrl = Server.MapPath("~/XML/" + FileName); 活頁簿.SaveAs(FileUrl); return(File(FileUrl, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", $"{lecture.Name}學生資料.xlsx")); }