做网站客户要求分期,如何注册公司地址定位,阿里服务器租用价格表,求网页设计与网站建设直接看代码吧#xff0c;主要逻辑吧excel的图片拿到 压缩上传获取url // 将文件转成XSSFWorkbook工作簿XSSFWorkbook wb new XSSFWorkbook(uploadFile);// 获取工作薄中第一个excel表格XSSFSheet sheet wb.getSheetAt(0);// 核心#xff1a;#xff1a;#xff1a;获取ex…直接看代码吧主要逻辑吧excel的图片拿到 压缩上传获取url // 将文件转成XSSFWorkbook工作簿XSSFWorkbook wb new XSSFWorkbook(uploadFile);// 获取工作薄中第一个excel表格XSSFSheet sheet wb.getSheetAt(0);// 核心获取excel表格中所有图片,处理图片上传到oss key:行号-列号MapString, ListString picturesMap getPictures(sheet);public MapString, ListString getPictures(XSSFSheet xssfSheet) throws IOException {MapString, ListString maps new LinkedHashMap();ListXSSFShape list xssfSheet.getDrawingPatriarch().getShapes();for (int i 0; i list.size(); i) {XSSFPicture picture (XSSFPicture) list.get(i);// 行号-列号XSSFClientAnchor xssfClientAnchor (XSSFClientAnchor) picture.getAnchor();// 获取图片XSSFPictureData pdata picture.getPictureData();byte[] data pdata.getData();InputStream inputStream new ByteArrayInputStream(data);byte[] scalePicLater scalePics(inputStream,0.5,0.5);String url ossFactory.build().upload(new ByteArrayInputStream(scalePicLater), IdUtil.objectId() .jpg);inputStream.close();// 行号-列号String key xssfClientAnchor.getRow1() - 1 - xssfClientAnchor.getCol1();if (maps.containsKey(key)) {ListString strUrl maps.get(key);strUrl.add(url);maps.put(key, strUrl);} else {ListString strUrl new ArrayList();strUrl.add(url);maps.put(key, strUrl);}}return maps;}public static byte[] scalePics(InputStream inputStream, double accuracy,double scale) throws IOException {// 压缩图片并保存到临时文件中File tempFile File.createTempFile(thumbnail, .jpg);Thumbnails.of(inputStream).scale(scale).outputQuality(accuracy).toFile(tempFile);// 读取临时文件的字节流设置到输出流中InputStream tempInputStream new FileInputStream(tempFile);byte[] buffer new byte[tempInputStream.available()];tempInputStream.read(buffer);tempInputStream.close();// 删除临时文件tempFile.delete();// 下载到本地// BufferedOutputStream bos new BufferedOutputStream(new FileOutputStream(C:\\Code\\upload\\1.jpg));// bos.write(buffer);// bos.close();return buffer;}
