利用POI在EXCEL表格中导入图片

public void importExcelForCode(int x, int y, int width, int height,
            String no) throws Exception {
            //原装的EXCEL模板 如果要创建新的 在NWE XSSFWorkbook()中不需要带参数
        InputStream i = new FileInputStream("E:\\x.xlsx");
        //导入我的图片
        BufferedImage image = ImageIO.read(new File("E:\\name.jpg"));
        XSSFWorkbook xssfWorkbook = new XSSFWorkbook(i);
        XSSFSheet sheet = xssfWorkbook.getSheetAt(0);
        XSSFDrawing xssfDrawing = sheet.createDrawingPatriarch();
        //字节流
        ByteArrayOutputStream bao = new ByteArrayOutputStream();
        ImageIO.write(image, "jpg", bao);
                //设置起始坐标,前四个是xy函数, 后四个是设置起始行列和图形行列 我选择后者
        XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, x, y, width
                + x, height + y);
        anchor.setAnchorType(0);
        //创建图片
        xssfDrawing.createPicture(anchor, xssfWorkbook.addPicture(
                bao.toByteArray(), XSSFWorkbook.PICTURE_TYPE_JPEG));
                //关闭流
        i.close();
        FileOutputStream fos = new FileOutputStream(new File(
                "E:\\x.xlsx"));
        xssfWorkbook.write(fos);
        new File("E:\\" + no + ".jpg").delete();
    }