easyexcel 导出数据锁定某个单元格

EasyExcel官方文档

新建controller

@RequestMapping("/excle")
    void excle() throws IOException {
        // 这里注意 有同学反应使用swagger 会导致各种问题，请直接用浏览器或者用postman
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
        String fileName = URLEncoder.encode("测试", "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), ComplexHeadData.class)
                .registerWriteHandler(new CustomCellWriteHandler())
                .sheet("模板")
                .doWrite(data