//==========导出Excel===========
@PermissionName("核保审核结果导出")
@RequestMapping("/underwrite_export")
@RequiresPermissions("underwrite:export")
@ResponseBody
public void exportFile(HttpServletResponse response) throws Exception {
// 1.文件下载响应头
response.setHeader("Content-Disposition", "attachment;filename=underwrite.xls");
// 2.响应到浏览器
WritableWorkbook workbook = Workbook.createWorkbook(response.getOutputStream());
// 创建工作簿sheet
WritableSheet sheet = workbook.createSheet("underwrite", 0);
// 3.设置column名
sheet.addCell(new Label(0, 0, "承保机构"));
sheet.addCell(new Label(1, 0, "申请单号"));
sheet.addCell(new Label(2, 0, "产品名称"));
sheet.addCell(new Label(3, 0, "投保人"));
sheet.addCell(new Label(4, 0, "申请时间"));
sheet.addCell(new Label(5, 0, "提交员工"));
sheet.addCell(new Label(6, 0, "提交状态"));
sheet.addCell(new Label(7, 0, "审核状态"));
sheet.addCell(new Label(8, 0, "额度"));
// 4.把核保的数据填充到工作簿中 service调用selectExport()查询数据库
List<UnderwriteWait> list = service.selectExport();
System.out.println(list.toArray());
try{
for (int i = 0, j = 1; i < list.size(); i++, j++) {
UnderwriteWait underwrite = list.get(i);
//System.out.println(underwrite);
//设置列宽
sheet.setColumnView(i, 16);
//重新设置部分列宽
sheet.setColumnView(3, 14);
sheet.setColumnView(6, 10);
sheet.setColumnView(7, 10);
//设置行高
sheet.setRowView(i, 350);
//设置字体的attribute
WritableFont font1=new WritableFont(WritableFont.createFont("楷体 _GB2312"), 12, WritableFont.NO_BOLD);
WritableCellFormat format1=new WritableCellFormat(font1);
System.out.println(underwrite.getId());
sheet.addCell(new Label(0, j, underwrite.getOrg().getName(),format1));
sheet.addCell(new Label(1, j, underwrite.getApplyordernumber(),format1));
sheet.addCell(new Label(2, j, underwrite.getCarinsuranc().getInsName(),format1));
sheet.addCell(new Label(3, j, underwrite.getClient().getName(),format1));
String applydate=underwrite.getApplydate().toLocaleString().substring(0,9);
sheet.addCell(new Label(4, j, applydate,format1));
sheet.addCell(new Label(5, j, underwrite.getEmployee().getRealname(),format1));
String stateApply=(underwrite.getStateApply().toString().equals("0")) ? "未审核":"已提交";
sheet.addCell(new Label(6, j,stateApply));
String stateAudit=(underwrite.getStateAudit().toString().equals("1")) ? "已提交":"已审核";
sheet.addCell(new Label(7, j, stateAudit));
sheet.addCell(new Label(8, j, underwrite.getAmount().toString(),format1));
}}catch (Exception e){
e.printStackTrace();
}
// 5.写入数据
workbook.write();
// 6.关闭资源
workbook.close();
}