导出word表格

最新推荐文章于 2023-12-21 18:06:09 发布

mjf853912229

最新推荐文章于 2023-12-21 18:06:09 发布

阅读量394

点赞数

本文链接：https://blog.csdn.net/mjf853912229/article/details/80771259

版权

class
{
@RequestMapping({"/getExportToWord"})
public void getExportToWord(HttpServletRequest request, HttpServletResponse response) throws Exception {
String taskId = request.getParameter("taskId");
String quotatype = request.getParameter("quotatype");
if(StringUtils.isNotEmpty(taskId)) {
AuditObjEvaltask task = (AuditObjEvaltask)this.auditObjEvaltaskServiceImpl.getById(taskId);
this.auditObjEvaltaskObjectsServiceImpl.getEvaltaskObjectsListByTaskId(taskId);
List taskquotaList = this.auditObjEvaltaskQuotaServiceImpl.getEvaltaskQuotaListByTaskId(taskId);
List taskcontentList = this.auditObjEvaltaskContentServiceImpl.getEvaltaskContentListByTaskId(taskId);
int quotaCount = taskquotaList.size();
byte[] content = (byte[])null;
String fileName = "";
String contents = "";
StringBuffer taskcontentSb = new StringBuffer();
String taskContent = "";
if("01".equals(quotatype)) {
taskcontentSb.append(" <h1 class=\'h1_title\' style=\'text-align:center;\'>风险评估1</h1> ");
} else {
taskcontentSb.append(" <h1 class=\'h1_title\' style=\'text-align:center;\'>风险评估2</h1> ");
}

taskcontentSb.append("<table class=\'tb_style4\' cellspacing=\'0\' style=\'border:solid #c4d3e3; border-width:1px 0px 0px 1px;\' cellpadding=\'0\'>");
taskcontentSb.append("<tr>");
taskcontentSb.append("<th style=\'background:#eff4fa; text-align:center;border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 100px;\'><label>任务名称</label></th>");
taskcontentSb.append("<td style=\'border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 300px;\'>" + task.getTaskname() + "</td>");
taskcontentSb.append("<th style=\'background:#eff4fa; text-align:center;border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 100px;\'><label>审计年份</label></th>");
taskcontentSb.append("<td style=\'border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 300px;\'>" + task.getAudityear() + "</td>");
taskcontentSb.append("</tr>");
taskcontentSb.append("<tr>");

for(int e = 0; e < taskquotaList.size(); ++e) {
taskcontentSb.append("<th style=\'background:#eff4fa; text-align:center;border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 100px;\'><label>" + ((AuditObjEvaltaskQuota)taskquotaList.get(e)).getQuota() + "</label></th>");
taskcontentSb.append("<td style=\'border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 300px;\'><label>权重：" + ((AuditObjEvaltaskQuota)taskquotaList.get(e)).getWeight() + "</label></td>");
if((e + 1) % 2 == 0) {
taskcontentSb.append("</tr><tr>");
} else if((e + 1) % 2 != 0 && e + 1 == quotaCount) {
taskcontentSb.append("<th style=\'background:#eff4fa; text-align:center;border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 100px;\'><label></label></th>");
taskcontentSb.append("<td style=\'border:solid #c4d3e3; border-width:0px 1px 1px 0px; padding:10px 0px;width: 300px;\'></td>");
}
}

taskcontentSb.append("</tr>");
taskcontentSb.append("</table>");
taskcontentSb.append("<br/>");
taskContent = taskcontentSb.toString();
if(!taskcontentList.isEmpty()) {
content = ((AuditObjEvaltaskContent)taskcontentList.get(0)).getContent();
contents = "<html>" + taskContent + new String(content) + "</html>";
if("01".equals(quotatype)) {
fileName = "领导-" + task.getTaskname() + "评估展示.doc";
} else {
fileName = "单位?-" + task.getTaskname() + "评估展示.doc";
}

try {
content = contents.getBytes("UTF-8");
} catch (UnsupportedEncodingException var17) {
var17.printStackTrace();
}
}

try {
response.reset();
response.setCharacterEncoding("UTF-8");
response.setContentType("application/vnd.ms-word;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes("gbk"), "iso8859-1"));
ServletOutputStream var18 = response.getOutputStream();
var18.write(content);
var18.flush();
var18.close();
response.flushBuffer();
} catch (Exception var16) {
var16.printStackTrace();
}
}

}
}

mjf853912229

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
导出word表格

class { @RequestMapping({"/getExportToWord"}) public void getExportToWord(HttpServletRequest request, HttpServletResponse response) throws Exception { String taskId = request.getParameter("ta...
复制链接

扫一扫