如何通过HSSFWorkbook设置图片大小

HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("Sheet1");

InputStream inputStream = new FileInputStream("图片路径");
byte[] bytes = IOUtils.toByteArray(inputStream);
int pictureIndex = workbook.addPicture(bytes, HSSFWorkbook.PICTURE_TYPE_JPEG); // 指定图片类型
CreationHelper helper = workbook.getCreationHelper();
Drawing drawing = sheet.createDrawingPatriarch();
ClientAnchor anchor = helper.createClientAnchor();
anchor.setCol1(0); // 设置图片插入列
anchor.setRow1(0); // 设置图片插入行
Picture picture = drawing.createPicture(anchor, pictureIndex);

picture.resize(); // 默认将图片调整为原始大小

// 可以通过设置比例系数来调整图片大小
// picture.resize(0.5); // 将图片缩小为原始大小的一半
// picture.resize(2); // 将图片放大为原始大小的两倍
// picture.resize(200, 100); // 将图片设置为指定宽度和高度

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.util.IOUtils;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

public class ExcelImageExample {

    public static void main(String[] args) throws Exception {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet("Sheet1");

        InputStream inputStream = new FileInputStream("图片路径");
        byte[] bytes = IOUtils.toByteArray(inputStream);
        int pictureIndex = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);
        CreationHelper helper = workbook.getCreationHelper();
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = helper.createClientAnchor();
        anchor.setCol1(0);
        anchor.setRow1(0);
        Picture picture = drawing.createPicture(anchor, pictureIndex);

        picture.resize();

        OutputStream outputStream = new FileOutputStream("输出Excel文件路径");
        workbook.write(outputStream);
        workbook.close();
        outputStream.close();
    }
}