POI 单元格设置字符类型

HSSFDataFormat df = workbook.createDataFormat(); // 此处设置数据格式
numberstyles = workbook.createCellStyle();
//numberstyles.setDataFormat(HSSFDataFormat.getBuiltinFormat("0.00"));
numberstyles.setDataFormat(df.getBuiltinFormat("#,##0.00"));//保留两位小数点
numberstyles.setAlignment(HorizontalAlignment.RIGHT);
numberstyles.setVerticalAlignment(VerticalAlignment.TOP);
numberstyles.setBorderLeft(BorderStyle.THIN);
numberstyles.setBorderBottom(BorderStyle.THIN);
numberstyles.setFont(fonts1);

 

 

double oderQuantity = uq.getOderQuantity().doubleValue();
cellHeader.setCellValue(oderQuantity);//