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

时间:2020-03-11 17:56:04   收藏:0   阅读:445
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"));



原文:https://www.cnblogs.com/ketoli/p/12462942.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!