easyExcel自定義字體大小

需求說明：

設(shè)置第二行的標(biāo)題字體為20號以及宋體暴区。

依賴

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'com.alibaba:easyexcel:2.2.7'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
    compileOnly 'org.projectlombok:lombok:1.18.26'
}

代碼

WebController

package cn.open.share.easyExcel.controller;

import cn.open.share.easyExcel.handler.CustomWriteHandler;
import cn.open.share.easyExcel.vo.ComplexHeadData;
import com.alibaba.excel.EasyExcel;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;
import java.util.stream.IntStream;

/**
 * @ClassName WebController
 * @Description easyExcel控制器
 * @Author GTY
 * @Date 2023/2/21 下午2:56
 * @Version 1.0
 */
@RestController
@RequestMapping("easyExcel/web")
public class WebController {

    /**
     * 文件下載（失敗了會返回一個有部分?jǐn)?shù)據(jù)的Excel）
     * <p>
     * 1. 創(chuàng)建excel對應(yīng)的實(shí)體對象 參照{(diào)@link }
     * <p>
     * 2. 設(shè)置返回的 參數(shù)
     * <p>
     * 3. 直接寫奢方，這里注意痕惋，finish的時候會自動關(guān)閉OutputStream,當(dāng)然你外面再關(guān)閉流問題不大
     */
    @GetMapping("download")
    public void download(HttpServletResponse response) throws IOException {
        // 這里注意 有同學(xué)反應(yīng)使用swagger 會導(dǎo)致各種問題翩蘸，請直接用瀏覽器或者用postman
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        // 這里URLEncoder.encode可以防止中文亂碼 當(dāng)然和easyexcel沒有關(guān)系
        String fileName = URLEncoder.encode("測試", "UTF-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), ComplexHeadData.class).sheet("模板").registerWriteHandler(new CustomWriteHandler()).doWrite(data());
    }


    private List<ComplexHeadData> data(){
        List<ComplexHeadData>  list = IntStream.rangeClosed(0, 10).mapToObj(item -> {
            ComplexHeadData complexHeadData = new ComplexHeadData();
            complexHeadData.setDoubleData(Double.valueOf(item));
            complexHeadData.setDate(new Date());
            complexHeadData.setString("test" + item);
            return complexHeadData;
        }).collect(Collectors.toList());
        return list;
    }
}

CustomWriteHandler

package cn.open.share.easyExcel.handler;

import com.alibaba.excel.write.handler.AbstractRowWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;

import java.util.stream.IntStream;

/**
 * @ClassName CustomWriteHandler
 * @Description 自定義頭
 * @Author GTY
 * @Date 2023/2/21 下午3:39
 * @Version 1.0
 */
public class CustomWriteHandler extends AbstractRowWriteHandler {

    /**
     * 行處理后
     * 第二行頭設(shè)置字體
     *
     * @param writeSheetHolder writeSheetHolder
     * @param writeTableHolder writeTableHolder
     * @param row              行
     * @param relativeRowIndex 行索引
     * @param isHead           是頭
     */
    @Override
    public void afterRowDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Integer relativeRowIndex, Boolean isHead) {

        if (isHead && relativeRowIndex ==1) {
            //創(chuàng)建字體樣式
            CellStyle cellStyle = row.getSheet().getWorkbook().createCellStyle();
            //獲取當(dāng)前行所有列
            int size = row.getPhysicalNumberOfCells();
            //遍歷所有列
            IntStream.rangeClosed(0,size-1).forEach(i ->{
                Cell cell = row.getCell(i);
                //克隆原來的樣式畦幢，只修改字體大小军拟，其他不變
                cellStyle.cloneStyleFrom(cell.getCellStyle());
                Font font = writeSheetHolder.getSheet().getWorkbook().createFont();
                font.setFontHeight((short) (22*20));//設(shè)置字體大小  22號
                font.setFontName("宋體");//設(shè)置字體
                cellStyle.setFont(font);
                cell.setCellStyle(cellStyle);//設(shè)置字體樣式
            });


        }
    }
}

ComplexHeadData

package cn.open.share.easyExcel.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.util.Date;

/**
 * @ClassName ComplexHeadData
 * @Description
 * @Author GTY
 * @Date 2023/2/21 下午3:11
 * @Version 1.0
 */
@Data
public class ComplexHeadData {
    @ExcelProperty({"主標(biāo)題", "字符串標(biāo)題"})
    private String string;
    @ExcelProperty({"主標(biāo)題", "日期標(biāo)題"})
    private Date date;
    @ExcelProperty({"主標(biāo)題", "數(shù)字標(biāo)題"})
    private Double doubleData;
}