POI Excel HSSFPicture 图像和尺寸

在使用POI Excel HSSFPicture时，我们可以方便地插入图像并设置其尺寸。POI是一个用于操作Microsoft Office文件的Java库，可以轻松地读取、创建和修改Excel文档。HSSFPicture是POI中用于处理图像的类，它提供了一些方法来操作图像的位置、大小和样式。

java
import org.apache.poi.hssf.usermodel.HSSFPicture;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
public class ExcelPictureExample {
    public static void main(String[] args) {
        try {
            // 创建一个HSSFWorkbook对象
            Workbook workbook = new HSSFWorkbook();
            // 创建一个HSSFSheet对象作为工作表
            Sheet sheet = workbook.createSheet("Sheet1");
            // 读取图像文件
            FileInputStream fis = new FileInputStream("image.jpg");
            BufferedImage image = ImageIO.read(fis);
            fis.close();
            // 将图像转换为字节数组
            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            ImageIO.write(image, "jpg", baos);
            byte[] imageData = baos.toByteArray();
            baos.close();
            // 添加图像到工作表中
            int pictureIndex = workbook.addPicture(imageData, Workbook.PICTURE_TYPE_JPEG);
            CreationHelper helper = workbook.getCreationHelper();
            Drawing drawing = sheet.createDrawingPatriarch();
            ClientAnchor anchor = helper.createClientAnchor();
            anchor.setCol1(1);
            anchor.setRow1(1);
            anchor.setCol2(5);
            anchor.setRow2(10);
            Picture picture = drawing.createPicture(anchor, pictureIndex);
            
            // 设置图像的尺寸
            picture.resize(0.5);
            // 保存Excel文件
            FileOutputStream fos = new FileOutputStream("output.xls");
            workbook.write(fos);
            fos.close();
            System.out.println("Excel文件已生成！");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}