content: package com.alibaba.easyexcel.test.demo.write;
  
  import com.alibaba.excel.util.BooleanUtils;
  import com.alibaba.excel.write.handler.RowWriteHandler;
  import com.alibaba.excel.write.handler.context.RowWriteHandlerContext;
  
  import lombok.extern.slf4j.Slf4j;
  import org.apache.poi.ss.usermodel.Comment;
  import org.apache.poi.ss.usermodel.Drawing;
  import org.apache.poi.ss.usermodel.Sheet;
  import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
  import org.apache.poi.xssf.usermodel.XSSFRichTextString;
  
  /**
   * 自定义拦截器.新增注释,第一行头加批注
   *
   * @author Jiaju Zhuang
   */
  @Slf4j
  public class CommentWriteHandler implements RowWriteHandler {
  
      @Override
      public void afterRowDispose(RowWriteHandlerContext context) {
          if (BooleanUtils.isTrue(context.getHead())) {
              Sheet sheet = context.getWriteSheetHolder().getSheet();
              Drawing<?> drawingPatriarch = sheet.createDrawingPatriarch();
              // 在第一行 第二列创建一个批注
              Comment comment =
                  drawingPatriarch.createCellComment(new XSSFClientAnchor(0, 0, 0, 0, (short)1, 0, (short)2, 1));
              // 输入批注信息
              comment.setString(new XSSFRichTextString("创建批注!"));
              // 将批注添加到单元格对象中
              sheet.getRow(0).getCell(1).setCellComment(comment);
          }
      }
  
  }
  