java POI实现Excel单元格数据格式化

 Workbook wb = new HSSFWorkbook();    Sheet sheet = wb.createSheet("format sheet");    CellStyle style;    DataFormat format = wb.createDataFormat();    Row row;    Cell cell;    short rowNum = 0;    short colNum = 0;    row = sheet.createRow(rowNum++);    cell = row.createCell(colNum);    cell.setCellValue(11111.25);    style = wb.createCellStyle();    style.setDataFormat(format.getFormat("0.0"));    cell.setCellStyle(style);    row = sheet.createRow(rowNum++);    cell = row.createCell(colNum);    cell.setCellValue(11111.25);    style = wb.createCellStyle();    style.setDataFormat(format.getFormat("#,##0.0000"));    cell.setCellStyle(style);    FileOutputStream fileOut = new FileOutputStream("E:\\standarcode\\workbook.xls");    wb.write(fileOut);    fileOut.close();

效果：