下面这个方法简单的介绍了如何使用C#导出数据表格
public ActionResult ExportExcel(int? AcademyId, int? MajorId, int? GradeId, int? ClassId, string strSearch)
{
ReturnJson msg = new ReturnJson();
var StudentLing = (from tbStudent in myModel.Student
join tbClass in myModel.Class on tbStudent.ClassID equals tbClass.ClassID
join tbGrade in myModel.Grade on tbClass.GradeID equals tbGrade.GradeID
join tbMajor in myModel.Major on tbGrade.MajorID equals tbMajor.MajorID
join tbAcademy in myModel.Academy on tbMajor.AcademyID equals tbAcademy.AcademyID
select new StudentVo
{
AcademyID = tbAcademy.AcademyID,
AcademyName = tbAcademy.AcademyName,
MajorID = tbMajor.MajorID,
MajorName = tbMajor.MajorName,
GradeID = tbGrade.GradeID,
GradeName = tbGrade.GradeName,
ClassID = tbClass.ClassID,
ClassName = tbClass.ClassName,
StudentID = tbStudent.StudentID,
StudentName = tbStudent.StudentName,
StudentSex = tbStudent.StudentSex,
StudentIDNum = tbStudent.StudentIDNum,
StudentTel = tbStudent.StudentTel,
StudentNumber = tbStudent.StudentNumber,
StudentPictureName = tbStudent.StudentPictureName
}).ToList();
if (AcademyId != null && A