java读取excel中的多图片

矫情吗；* 2022-08-08 14:50 407阅读 0赞

excel文件如图![Center][]，获取张三的基本信息及图片信息。

代码如下：

需要导入poi相关的jar 版本3.9及以上  
public class ReadExcel \{  
   
 public static void main(String\[\] args) throws Exception \{  
  InputStream inp = new FileInputStream("F:\\\\xxx.xls");   
     HSSFWorkbook workbook = (HSSFWorkbook) WorkbookFactory.create(inp);   
        List<HSSFPictureData> pictures = workbook.getAllPictures();   
        HSSFSheet sheet = (HSSFSheet) workbook.getSheetAt(0);   
        Map<String,Object> map = new HashMap<String,Object>();  
         
     for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) \{   
            HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();   
         if (shape instanceof HSSFPicture) \{   
                HSSFPicture pic = (HSSFPicture) shape;   
                int row = anchor.getRow2();   
                int col = anchor.getCol2();  
             System.out.println("--->" + anchor.getRow2() + ":"  + anchor.getCol2());  
             //map.put(row+":"+col, row+":"+col);  
             int pictureIndex = pic.getPictureIndex()-1;   
             HSSFPictureData picData = pictures.get(pictureIndex);   
             System.out.println("--->" + picData);  
             map.put(row+":"+col, picData);  
             savePic(UUID.randomUUID().toString(), picData);   
            \}   
      \}  
      
     System.out.println(map);  
 \}  
   
 private static void savePic(String i, PictureData pic) throws Exception \{   
        String ext = pic.suggestFileExtension();   
        byte\[\] data = pic.getData();   
        if (ext.equals("jpeg")) \{   
            FileOutputStream out = new FileOutputStream("F:\\\\" + i + ".jpg");  
            out.write(data);   
            out.close();   
         File file = new File("F:\\\\" + i + ".jpg");  
         FileInputStream in = new FileInputStream(file);  
         System.out.println("in===>"+in);  
         if(file.isFile())\{  
          file.delete();  
          System.out.println("=============delete");  
         \}  
          
        \}   
       /\* if (ext.equals("png")) \{   
            FileOutputStream out = new FileOutputStream("F:\\\\" + i + ".jpg");   
            out.write(data);   
            out.close();   
        \}  \*/  
 \}  
\}

[Center]: /images/20220731/9ef18ae9d8d24f7e8e831b1ac2186409.png