MVC控制器导出

public ActionResult ExportFile()
{
//判断是否有数据
if (Session[“StuList”]!=null&& (Session[“StuList”] as List).Any())
{
var stulist = Session[“StuList”] as List;
var dt = new DataTable();
var props = typeof(StudentInfo).GetProperties();
//添加列
dt.Columns.AddRange(props.Select(p => new DataColumn(p.Name, p.PropertyType)).ToArray());
//循环添加行
foreach (var stu in stulist)
{
//创建新行
DataRow dr = dt.NewRow();
foreach (var prop in props)
{
//dr[“Id”]=;
dr[prop.Name] = prop.GetValue(stu);
}
dt.Rows.Add(dr);
}
//定义文件名
var filename = “导出学生信息.xls”;
var sm = NPOIExcelHelper.TableToExcelForMVC(dt, filename);
return File(sm, “application/vnd.ms-excel”,filename);
}
else
{
return View(“ShowStudent”, Session[“StuList”]);
}
}