easyExcel设置水印

wangchen24

已于 2023-03-06 11:07:36 修改

阅读量2.8k

点赞数 1

分类专栏： excel 文章标签： java

于 2022-12-06 20:54:51 首次发布

本文链接：https://blog.csdn.net/wangchen24/article/details/128209877

版权

1、依赖导入

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.1.0</version>
        </dependency>
<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>ooxml-schemas</artifactId>
            <version>1.4</version>
        </dependency>

poi的依赖是样式设置需要用到

2、自定义水印处理器

package com.XXX.common.utils.easyexcel;


import com.alibaba.excel.write.handler.SheetWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder;
import com.XXX.common.exception.CustomException;
import com.XXX.common.utils.SecurityUtils;
import com.XXX.project.system.domain.SysUser;
import lombok.SneakyThrows;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFRelation;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import javax.imageio.ImageIO;
import java.awt.*;
import java.awt.font.FontRenderContext;
import java.awt.geom.Rectangle2D;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.IOException;

/**
 * 添加水印
 *
 * @author wangchen
 * @date 2022/11/30 16:07
 */
public class CustomWaterMarkHandler implements SheetWriteHandler {


    public static ByteArrayOutputStream createWaterMark(String content) throws IOException {
          int width = 400;
        int height = 200;
        // 获取bufferedImage对象
        BufferedImage image = new

最低0.47元/天解锁文章