poi excel设置cell 格式

红太狼 2022-09-12 10:55 480阅读 0赞

### 1. 生成cell 样式 ###

/** * 获取日期格式单元格的样式 * * @return 单元格样式 * @author leiming5 */
        private CellStyle getDateCellStyle(Workbook workbook) { 
            CellStyle CellStyleDate = workbook.createCellStyle();
            DataFormat df = workbook.createDataFormat();
            CellStyleDate.setDataFormat(df.getFormat(DateUtils.SPECIAL_DATE_PATTERN));//
            // 背景色的设定 自动换行
            CellStyleDate.setWrapText(true);
            // 设置字体
            Font font = workbook.createFont();
            font.setBold(true);
            font.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
            CellStyleDate.setFont(font);
            // 水平居中,垂直居中
            CellStyleDate.setAlignment(HorizontalAlignment.CENTER);
            CellStyleDate.setVerticalAlignment(VerticalAlignment.CENTER);
            CellStyleDate.setFillForegroundColor(IndexedColors.LIGHT_CORNFLOWER_BLUE.getIndex());
            CellStyleDate.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    
            return CellStyleDate;
        }

### 2. 生成下拉框 ###

/** * 生成下拉框 * * @param rowNumber 目标行号 * @param colNumber 目标列号 * @param sheet sheet * @param list 下拉框数据 * @author: leiming5 */
        private void generateSelectBox(int rowNumber, int colNumber, Sheet sheet, List<String> list) { 
            //生成下拉列表
            CellRangeAddressList regions = new CellRangeAddressList(rowNumber, rowNumber, colNumber, colNumber);
            DataValidation validation;
            XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSheet) sheet);
    
            DataValidationConstraint constraint = new XSSFDataValidationConstraint(list.toArray(new String[0]));
            validation = helper.createValidation(constraint, regions);
    
            sheet.addValidationData(validation);
        }