jxl 导出excel中图片 行不对应

今天郁闷了一天，到晚上终于找到答案了，原来用jxl导出excel中的图片的顺序是图片在excel中层的叠放次序，点到此希望对大家有帮助。

 

InputStream is = new FileInputStream(filePath);//创建输入
   Workbook rwb = Workbook.getWorkbook(is);
   Sheet rs = rwb.getSheet(0); //读取第一个sheet 

 

 //图片处理
            for(int i=0;i<rs.getNumberOfImages();i++) {
                //图片的大小
                if(rs.getDrawing(i).getImageData().length>0){
                    //生成图片，结束For 语句
                 InputStream inStream = new ByteArrayInputStream(rs.getDrawing(i).getImageData());
                 String filename=ServletActionContext.getServletContext().getRealPath("/")+"fileTemp/"+fileName+i+".jpg";
                 File file=new File(filename);
                 FileOutputStream outStream=new FileOutputStream(file);
                 byte[] buffer=new byte[100000];
                 int length=-1;
                 while((length=inStream.read(buffer))!=-1){
                  outStream.write(buffer,0,length);
                 }
                 inStream.close();
                 outStream.close();
                }
            }