使用Apache POI从excel文件中获取图像及其位置

3 回答

• 0

  看看这里：

  http://poi.apache.org/components/spreadsheet/quick-guide.html#Images

  样品：

  List lst = workbook.getAllPictures();
  
  for (Iterator it = lst.iterator(); it.hasNext(); ) {
  
      PictureData pict = (PictureData)it.next();
  
      String ext = pict.suggestFileExtension();
  
      byte[] data = pict.getData();
  
      if (ext.equals("jpeg")) {
  
        FileOutputStream out = new FileOutputStream("pict.jpg");
  
        out.write(data);
  
        out.close();
  
      }
  }
  

  在此之后，您可以使用像ImageInfo这样的工具来扩展Magick以找出各种配置 . 哟甚至可以将图像转换为不同的大小 .

  看看这堂课：

  http://blog.jaimon.co.uk/simpleimageinfo/SimpleImageInfo.java.html

  • 希望这可以帮助

  回复于 2024-04-29T17:04:47+08:00
• 4

  我希望这段代码会有所帮助）

  XSSFDrawing dp = workbook.getSheetAt(1).createDrawingPatriarch();
      List<XSSFShape> pics = dp.getShapes();
      XSSFPicture inpPic = (XSSFPicture)pics.get(0);
  
      XSSFClientAnchor clientAnchor = inpPic.getClientAnchor();
      inpPic.getShapeName(); // узнаю название картинки
      PictureData pict = inpPic.getPictureData();
      FileOutputStream out = new FileOutputStream("pict.jpg");
      byte[] data = pict.getData();
      out.write(data);
      out.close();
      System.out.println("col1: " + clientAnchor.getCol1() + ", col2: " + clientAnchor.getCol2() + ", row1: " + clientAnchor.getRow1() + ", row2: " + clientAnchor.getRow2());
      System.out.println("x1: " + clientAnchor.getDx1() + ", x2: " + clientAnchor.getDx2() +  ", y1: " + clientAnchor.getDy1() +  ", y2: " + clientAnchor.getDy2());
  

  回复于 2024-04-29T17:04:47+08:00
• 2

  如果你不想使用迭代器（因为有些时候它们很重）

  public List readDrawing(Workbook workbook) throws Exception {
      List list = workbook.getAllPictures();
  
      for (int i=0; i<list.size(); i++) {
          PictureData picture = (PictureData) list.get(i);
  
          String ext = picture.suggestFileExtension();
          byte[] data = picture.getData();
  
          FileOutputStream out = new FileOutputStream("imageName" + "." + ext);
          out.write(data);
          out.close();
      }
  
      return list;
  }
  

  回复于 2024-04-29T17:04:47+08:00