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"));

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

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