失眠网,内容丰富有趣,生活中的好帮手!
失眠网 > Easypoi Excel导出和word导出带图片(图片不显示问题必须用字节)

Easypoi Excel导出和word导出带图片(图片不显示问题必须用字节)

时间:2019-02-11 05:38:02

相关推荐

Easypoi Excel导出和word导出带图片(图片不显示问题必须用字节)

Maven包 其他的包Excel导出会出现空指针问题

<dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-base</artifactId><version>3.3.0</version></dependency><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-web</artifactId><version>3.3.0</version></dependency><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-annotation</artifactId><version>3.3.0</version></dependency>

//图片到byte数组public byte[] image2byte(String path){byte[] data = null;FileImageInputStream input = null;try {input = new FileImageInputStream(new File(path));ByteArrayOutputStream output = new ByteArrayOutputStream();byte[] buf = new byte[1024];int numBytesRead = 0;while ((numBytesRead = input.read(buf)) != -1) {output.write(buf, 0, numBytesRead);}data = output.toByteArray();output.close();input.close();}catch (FileNotFoundException ex1) {ex1.printStackTrace();}catch (IOException ex1) {ex1.printStackTrace();}return data;}

//图片必须转byte 否则不显示WordImageEntity imageEntity = new WordImageEntity() ;imageEntity.setHeight(145);imageEntity.setWidth(120);String url = registrationForm.getPhoto().getFileUrl() ;// String path = fileRepository.getRealPath(sysUser.getPictureUrl()) ;// imageEntity.setUrl(url);// imageEntity.setType(WordImageEntity.URL);byte[] imgdata = image2byte(url);imageEntity.setData(imgdata);imageEntity.setType(WordImageEntity.Data);map.put("picture", imageEntity);String name = "" ;try {XWPFDocument doc = WordExportUtil.exportWord07("1.docx", map);name = IdUtils.simpleUUID()+".docx" ;//如果没此路径 创建FileUtils.mkdirs(localPath);FileOutputStream fos = new FileOutputStream(localPath+name);doc.write(fos);fos.close();} catch (Exception e) {e.printStackTrace();}

如果觉得《Easypoi Excel导出和word导出带图片(图片不显示问题必须用字节)》对你有帮助,请点赞、收藏,并留下你的观点哦!

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。