MVC导出数据到EXCEL新方法：将视图或分部视图转换为HTML后再直接返回FileResult_html/css_WEB-ITnose

@model IEnumerable@using PagedList.Mvc; @foreach (var item in Model) { string className = ""; if (item.Status == "已审核未处理") { className = "uncl_yellow"; if (item.AuditDatetime != null && DateTime.Now > ((DateTime)item.AuditDatetime).AddHours(24)) { className = "uncl_red"; } }  } 
 
 
 
意见ID
 
组 织
 
车牌
 
车型
 
皇家版
 
客户
 
客户电话
 
责任部门
 
责任班组
 
业务顾问
 
意见类型
 
状态
 
录入员
 
录入时间
 
 
 
 
@item.Id
 
@item.OrgName
 
@item.PlateNo
 
@item.Model
 
@item.IsRoyalVer
 
@item.CustomerName
 
@item.CustomerPhoneNo
 
@item.RelevantDept
 
@item.RelevantGroup
 
@item.Consultant
 
@item.Type
 
@item.Status
 
@item.CreateBy
 
@string.Format("{0:g}", item.CreateDatetime)
 
@if(true!=ViewBag.NoPaging){ @Html.PagedListPager(Model as PagedList.IPagedList, page => string.Format("javascript:turnPage({0});", page), PagedListRenderOptions.ClassicPlusFirstAndLast)}

 [NonAction] protected string RenderViewToString(Controller controller, string viewName, string masterName) { IView view = ViewEngines.Engines.FindView(controller.ControllerContext, viewName, masterName).View; using (StringWriter writer = new StringWriter()) { ViewContext viewContext = new ViewContext(controller.ControllerContext, view, controller.ViewData, controller.TempData, writer); viewContext.View.Render(viewContext, writer); return writer.ToString(); } } [NonAction] protected string RenderPartialViewToString(Controller controller, string partialViewName) { IView view = ViewEngines.Engines.FindPartialView(controller.ControllerContext, partialViewName).View; using (StringWriter writer = new StringWriter()) { ViewContext viewContext = new ViewContext(controller.ControllerContext, view, controller.ViewData, controller.TempData, writer); viewContext.View.Render(viewContext, writer); return writer.ToString(); } }

 public ActionResult Export(DataFilter[] filters) { var resultList = DataProvider.GetCustomerCommentInfos(filters).OrderBy(t => t.CreateDatetime); ViewBag.NoPaging = true; ViewData.Model = resultList; string viewHtml = RenderPartialViewToString(this, "IndexDataList"); return File(System.Text.Encoding.UTF8.GetBytes(viewHtml), "application/ms-excel", string.Format("ccpi_{0}.xls", Guid.NewGuid())); }