Java Swing使用POI在生成的excel中插入图片

冷不防 2022-01-17 01:17 328阅读 0赞

上关键代码：

try {
    		        
    		        ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();  
    		        bufferImg = ImageIO.read(new File("E:/ec_workspace/Ftest/jpanel.jpg"));  
    		        ImageIO.write(bufferImg, "jpg", byteArrayOut);
    		        
    		        //创建HSSF工作薄
    				XSSFWorkbook workbook = new XSSFWorkbook();
    				
    		        //创建一个Sheet页
    		        XSSFSheet sheet = workbook.createSheet("123");
    		        XSSFDrawing picture = sheet.createDrawingPatriarch();
    
                      
    		        XSSFClientAnchor anchor = new XSSFClientAnchor(1, 1, 1, 1, 10, 1, 24, 22);
    		        picture.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_JPEG));
    		        
    		        
    		        
    		        //保存到本地
    		        FileOutputStream outputStream = new FileOutputStream(file);
    		        //将Excel写入输出流中
    		        workbook.write(outputStream);
    		        outputStream.flush();
    		        outputStream.close();
    				
    			} catch (IOException e) {
    				e.printStackTrace();
    			}

这里有个关键的地方就是XSSFClientAnchor的参数设置

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>参数</td> 
   <td>说明</td> 
  </tr> 
  <tr> 
   <td>dx1</td> 
   <td>第1个单元格中x轴的偏移量</td> 
  </tr> 
  <tr> 
   <td>dy1</td> 
   <td>第1个单元格中y轴的偏移量</td> 
  </tr> 
  <tr> 
   <td>dx2</td> 
   <td>第2个单元格中x轴的偏移量</td> 
  </tr> 
  <tr> 
   <td>dy2</td> 
   <td>第2个单元格中y轴的偏移量</td> 
  </tr> 
  <tr> 
   <td>col1</td> 
   <td>第1个单元格的列号</td> 
  </tr> 
  <tr> 
   <td>row1</td> 
   <td>第1个单元格的行号</td> 
  </tr> 
  <tr> 
   <td>col2</td> 
   <td>第2个单元格的列号</td> 
  </tr> 
  <tr> 
   <td>row2</td> 
   <td>第2个单元格的行号</td> 
  </tr> 
 </tbody> 
</table>