POI导出EXCLE时候设置单元格为金额样式,三位一分,保留2位小数

HSSFRow row = sheet.createRow(0)
HSSFCell cell1 = row.createCell(0);
HSSFCellStyle style = workbook.createCellStyle();
// 边框设置
style.setBorderBottom(BorderStyle.THIN);

style.setBorderLeft(BorderStyle.THIN);
style.setBorderRight(BorderStyle.THIN);
style.setBorderTop(BorderStyle.THIN);
style.setVerticalAlignment(VerticalAlignment.CENTER);
// 字体居中
style.setAlignment(align);
//设置金额格式
style
.setDataFormat(HSSFDataFormat.getBuiltinFormat("#,##0.00"));



posted @ 2020-03-11 16:01  凉了记忆  阅读(2870)  评论(0编辑  收藏  举报