今天郁闷了一天,到晚上终于找到答案了,原来用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();
}
}