public ActionResult RenderToExcel(PubPage fg) { string sql = "select Telephone,Pwd from SystemUser"; var dt = _iSysUserServices.ToDataTable(sql, null); string[] Telephone = { "手机号", "密码" }; for (int i = 0; i < dt.Columns.Count; i++) { dt.Columns[i].ColumnName = Telephone[i]; } var ms = NpoiHelper.RenderToExcel(dt); var xlsx = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; var xls = "application/vnd.ms-excel"; return(File(ms, xls, "用户信息" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls")); }