public HttpServletResponse exportExcel(HttpServletResponse response,List<PayFlowListVo> results) {
try {
String fileName="XXZF_" + ".xls";
response.reset();
response.setHeader("Content-disposition", "attachment; filename="+ fileName);
response.setContentType("application/vnd.ms-excel");
OutputStream os = response.getOutputStream();
WritableWorkbook wbook = Workbook.createWorkbook(os);
// --
WritableFont writableFont = new WritableFont(WritableFont.createFont(" "), 10,
WritableFont.BOLD, false,UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat wcfTitle = new WritableCellFormat(writableFont);
wcfTitle.setAlignment(Alignment.CENTRE);//
wcfTitle.setVerticalAlignment(VerticalAlignment.CENTRE);//
wcfTitle.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);//
wcfTitle.setWrap(true);//
// --
WritableFont wfContentCenter = new WritableFont(WritableFont.createFont(" "), 10,
WritableFont.NO_BOLD,false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat wcfContentCenter = new WritableCellFormat(wfContentCenter);
wcfContentCenter.setAlignment(Alignment.CENTRE);
wcfContentCenter.setVerticalAlignment(VerticalAlignment.CENTRE);
wcfContentCenter.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);//
wcfContentCenter.setWrap(true);
//
WritableFont wfFont = new WritableFont(WritableFont.createFont(" "), 10,
WritableFont.NO_BOLD,false,UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
NumberFormat numberFormatTwo = new NumberFormat("0.00");
WritableCellFormat wcfContentRightTwo = new WritableCellFormat(wfFont, numberFormatTwo);
wcfContentRightTwo.setAlignment(Alignment.RIGHT);
wcfContentRightTwo.setVerticalAlignment(VerticalAlignment.CENTRE);
wcfContentRightTwo.setBorder(Border.ALL, BorderLineStyle.THIN, Colour.BLACK);//
wcfContentRightTwo.setWrap(true);
WritableSheet wsheet = wbook.createSheet(" ", 0); // sheet
//
wsheet.setColumnView(0, 10);
wsheet.setColumnView(1, 25);
wsheet.setColumnView(2, 25);
wsheet.setColumnView(3, 25);
wsheet.setColumnView(4, 25);
wsheet.setColumnView(5, 15);
wsheet.setColumnView(6, 25);
wsheet.setColumnView(7, 15);
wsheet.setColumnView(8, 15);
wsheet.setColumnView(9, 25);
wsheet.setColumnView(10, 25);
wsheet.setColumnView(11, 15);
wsheet.setColumnView(12, 15);
wsheet.setColumnView(13, 15);
wsheet.setColumnView(14, 30);
wsheet.mergeCells(0, 0, 14, 1);
wsheet.addCell(new Label(0,0," ",wcfTitle));
//
wsheet.addCell(new Label(0, 2, " ", wcfTitle));
wsheet.addCell(new Label(1, 2, " ", wcfTitle));
wsheet.addCell(new Label(2, 2, " ", wcfTitle));
wsheet.addCell(new Label(3, 2, " ", wcfTitle));
wsheet.addCell(new Label(4, 2, " ", wcfTitle));
wsheet.addCell(new Label(5, 2, " ", wcfTitle));
wsheet.addCell(new Label(6, 2, " ", wcfTitle));
wsheet.addCell(new Label(7, 2, " ", wcfTitle));
wsheet.addCell(new Label(8, 2, " ", wcfTitle));
wsheet.addCell(new Label(9, 2, " ", wcfTitle));
wsheet.addCell(new Label(10, 2, " ", wcfTitle));
wsheet.addCell(new Label(11, 2, " ", wcfTitle));
wsheet.addCell(new Label(12, 2, " ", wcfTitle));
wsheet.addCell(new Label(13, 2, " ", wcfTitle));
wsheet.addCell(new Label(14, 2, " ", wcfTitle));
// wsheet.addCell(new Label(13, 2, " ", wcfTitle));
int row = 3;//
int cell;//
//
if(results.size()<0)
return null;
for(PayFlowListVo pv : results){
cell = 0;
wsheet.addCell(new Label(cell++, row, row-2+ "", wcfContentCenter));
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayeeAccount()) ? "" :
pv.getPayeeAccount() + "", wcfContentCenter));//
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayeeName()) ? "" :
pv.getPayeeName() + "", wcfContentCenter));//
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayerAccount()) ? "" :
pv.getPayerAccount() + "", wcfContentCenter));//
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayerName()) ? "" :
pv.getPayerName() + "", wcfContentCenter));//
//
//wsheet.addCell(new Label(cell++, row, pv.getAmount() == null ? "" : (StringUtils.isBlank(pv.getAmount().toString()) ? "":
//(pv.getAmount().doubleValue()==0?"0.00":BigDecimalUtil.formateBigDecimal(pv.getAmount()))) + "", wcfContentCenter));
wsheet.addCell(new Number(cell++, row, pv.getAmount()==null ? new Double(0): pv.getAmount().doubleValue(),wcfContentRightTwo));
//
/*wsheet.addCell(new Number(cell++, row, pv.getHandlingFee()==null ? new Double(0): pv.getHandlingFee().doubleValue(),wcfContentRightTwo));
//
wsheet.addCell(new Number(cell++, row, pv.getReceivable()==null ? new Double(0): pv.getReceivable().doubleValue(),wcfContentRightTwo));*/
//
wsheet.addCell(new Label(cell++, row, pv.getCreateTime() == null ? "" : (StringUtils.isBlank(pv.getCreateTime().toString()) ? "" :
TimeUtil.getYMDHMS(pv.getCreateTime())) + "", wcfContentCenter));//
wsheet.addCell(new Label(cell++, row, pv.getPayDate()==null ? "" : (StringUtils.isBlank(pv.getPayDate().toString()) ? "" :
TimeUtil.getYMD(pv.getPayDate())) + "", wcfContentCenter));//
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayType()) ? "" : getStatusDesc(PAY_TYPE, pv.getPayType()) + "", wcfContentCenter));
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getOrderId()) ? "" : pv.getOrderId() + "", wcfContentCenter));
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayFlowId()) ? "" : pv.getPayFlowId() + "", wcfContentCenter));
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getPayStatus()) ? "" : getStatusDesc(PAY_STATUS, pv.getPayStatus()) + "", wcfContentCenter));
// ( )
wsheet.addCell(new Label(cell++, row, " ",wcfContentCenter));
//
wsheet.addCell(new Label(cell++, row, StringUtils.isBlank(pv.getConfirmor()) ? "":pv.getConfirmor() + "" ,wcfContentCenter));
//
wsheet.addCell(new Label(cell++, row, pv.getConfirmTime() == null ? "":TimeUtil.getYMDHMS(pv.getConfirmTime()) + "",wcfContentCenter));
row++;
}
wbook.write(); //
wbook.close();
os.close();
response.flushBuffer();
} catch (Exception ex) {
log.error("exportExcel:", ex);
}
return response;
}