CellStyleBuilder.java

package com.alibaba.easyexcel.test;

import lombok.Data;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.ss.usermodel.*;

/**
 * @Author WL
 * @Date 2025/2/19 17:18
 * @Version 1.0
 */
@Slf4j
@Data
public class CellStyleBuilder {
    /**
     * 数值类型，保留整数
     */
    public static final String NUMBER_FORMAT_0 = "0_ ";
    /**
     * 数值类型，保留2位小数
     */
    public static final String NUMBER_FORMAT_2 = "0.00_ ";

    private Workbook workbook;
    private CellStyle cellstyle;

    public CellStyleBuilder(Workbook workbook) {
        this.workbook = workbook;
        this.cellstyle = workbook.createCellStyle();
    }

    public CellStyle build() {
        return cellstyle;
    }
    public CellStyleBuilder setFont(Object... fontArr) {
        Font font = this.workbook.createFont();
        try {
            for (int i = 0; i < fontArr.length; i++) {
                switch (i) {
                    case 0:
                        font.setFontName(String.valueOf(fontArr[i]));
                        continue;
                    case 1:
                        font.setFontHeightInPoints(Short.parseShort(String.valueOf(fontArr[1])));
                        continue;
                    case 2:
                        font.setBold(Boolean.parseBoolean(String.valueOf(fontArr[2])));
                        continue;
                    default:
                        log.warn("字体参数设置失败!");
                        break;
                }
            }
        } catch (Exception e) {
            throw new RuntimeException("excel字体设置失败!");
        }
        cellstyle.setFont(font);
        return this;
    }

    public CellStyleBuilder setWrapText(Boolean flag) {
        cellstyle.setWrapText(flag);
        return this;
    }

    public CellStyleBuilder setAlignment(HorizontalAlignment horizontalAlignment) {
        cellstyle.setAlignment(horizontalAlignment);
        return this;
    }

    public CellStyleBuilder setVerticalAlignment(VerticalAlignment verticalAlignment) {
        cellstyle.setVerticalAlignment(verticalAlignment);
        return this;
    }

    public CellStyleBuilder setDataFormat(String format) {
        DataFormat dataFormat = this.workbook.createDataFormat();
        cellstyle.setDataFormat(dataFormat.getFormat(format));
        return this;
    }
}

Test.java

package com.alibaba.easyexcel.test.util;

import com.alibaba.easyexcel.test.CellStyleBuilder;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * @Author WL
 * @Date 2025/2/19 17:32
 * @Version 1.0
 */
public class Test {
    public static void main(String[] args) {

        Workbook workbook = new XSSFWorkbook(); // 或者使用HSSFWorkbook，取决于你的需求
        Sheet sheet = workbook.createSheet("Example Sheet");
        Row row = sheet.createRow(0);
        Cell cell = row.createCell(0);
        cell.setCellValue("Hello World");
        cell.setCellStyle(new CellStyleBuilder(workbook)
                .setFont("宋体", 14, true)
                .setWrapText(true)
                .setAlignment(HorizontalAlignment.CENTER)
                .setVerticalAlignment(VerticalAlignment.CENTER)
                .setDataFormat(CellStyleBuilder.NUMBER_FORMAT_2)
                .build());
    }
}