java中excel导入图片_java POI实现向Excel中插入图片

Java POI可以实现向Excel中插入图片，下面是一个简单的示例代码：

public static void insertImage(String imagePath, String sheetName, int row, int column, int width, int height) throws IOException {
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet(sheetName);
    InputStream inputStream = new FileInputStream(imagePath);
    byte[] bytes = IOUtils.toByteArray(inputStream);
    int pictureIndex = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);
    Drawing drawing = sheet.createDrawingPatriarch();
    ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, column, row, column + 1, row + 1);
    Picture picture = drawing.createPicture(anchor, pictureIndex);
    picture.resize(width, height);
    FileOutputStream fileOutputStream = new FileOutputStream("output.xlsx");
    workbook.write(fileOutputStream);
    fileOutputStream.close();
}

该方法接受以下参数：

- `imagePath`：要插入的图片路径
- `sheetName`：要插入图片的工作表名称
- `row`：图片插入行号
- `column`：图片插入列号
- `width`：图片宽度
- `height`：图片高度

该方法会将图片插入到指定的Excel工作簿中，并将其保存为`output.xlsx`文件。