POI本地接口获取图片导出到EXCEL

你的名字 2023-10-01 10:57 29阅读 0赞

1.先通过HttpServletRequest获取本地接口http:/ip:xxxx(端口号)

String url = request.getHeader("Origin");

2.再在接口后面加上获取图片的方法

String wholeurl = url+图片接口;

3.将图片插入到EXCEL里

/*带图片的插入*/
       private static  Integer writeTablePicBodyOrFooterFromMapList(List<Map<String,Object>> list,Integer rowIndex,int maxcols,List<String> fieldList,HSSFSheet sheet,HSSFWorkbook workbook,TableType type) throws Exception{
        
            //正式的数据
            for (int i = 0; i < list.size(); i++) {
        
                HSSFRow row = sheet.createRow(rowIndex);
                Map<String,Object> vo = list.get(i); // 得到导出对象.
                for (int j = 0; j < maxcols; j++) {
        
                    HSSFCell cell = row.createCell(j);
                    if(type==TableType.FOOTER)  {
        cell.setCellStyle(getFooterCellStyler(workbook));}else {
        
                        cell.setCellStyle(getBoodyCellStyler(workbook));
                    }
                    // 取得类型,并根据对象类型设置值.
                    if (vo.get(fieldList.get(j)) == null) {
        
                        cell.setCellValue("");// 如果数据是null,就填入空格.
                    }else {
        
                        Class<?> fieldType=vo.get(fieldList.get(j)).getClass();
                        if(String.class == fieldType) {
        
                            if ((String)vo.get(fieldList.get(j))!=null&&((String)vo.get(fieldList.get(j))).indexOf("http://")!=-1){
        
                                row.setHeightInPoints(50);
                                sheet.setColumnWidth(j, 256*10+184);
                                HSSFPatriarch patriarch=sheet.createDrawingPatriarch();
                                setpic(patriarch,workbook,i+rowIndex,j,1,1,(String)vo.get(fieldList.get(j)));
                                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                                cell.setCellValue(((String) vo.get(fieldList.get(j))).substring(47));
                            } else {
        
                                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                                cell.setCellValue((String) vo.get(fieldList.get(j)));// 如果数据存在就填入,不存在填入空格.
                            }
                        } else if ((Integer.TYPE == fieldType) || (Integer.class == fieldType)) {
        
                            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
                            Integer value=(Integer) vo.get(fieldList.get(j));
                            cell.setCellValue(value);
                        } else if ((Long.TYPE == fieldType) || (Long.class == fieldType)) {
        
                            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
                            cell.setCellValue((Long)vo.get(fieldList.get(j)));
                        } else if ((Float.TYPE == fieldType) || (Float.class == fieldType)) {
        
                            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
                            cell.setCellValue((Float)vo.get(fieldList.get(j)));
                        } else if (Double.TYPE == fieldType||Double.class == fieldType) {
        
                            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
                            Double value=(Double) vo.get(fieldList.get(j));
                            cell.setCellValue(value);
                        } else if ((BigDecimal.class == fieldType)) {
          //一般数据库传过来的map数字都是这种类型
                            Double value = ((BigDecimal) vo.get(fieldList.get(j))).doubleValue();
                            cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
                            cell.setCellValue(value);
                        } else if (Character.TYPE == fieldType) {
        
    
                        }
                    }
                }
                rowIndex++;
            }
            return rowIndex;
        }
        private  static void setpic(HSSFPatriarch patriarch,HSSFWorkbook workbook,int rowNum,int colNum,int rowspan,int colspan,String picurl) throws Exception{
        
            // 先把读进来的图片放到一个ByteArrayOutputStream中，以便产生ByteArray
            ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
            URL url = new URL(picurl);
            HttpURLConnection httpUrl = (HttpURLConnection) url.openConnection();
            httpUrl.connect();
            //将图片读到BufferedImage
            BufferedImage bufferImg = ImageIO.read(httpUrl.getInputStream());
            if (bufferImg!=null)
            ImageIO.write(bufferImg, "jpg", byteArrayOut);
            httpUrl.disconnect();
            /**
             * 该构造函数有8个参数
             * 前四个参数是控制图片在单元格的位置，分别是图片距离单元格left，top，right，bottom的像素距离
             * 后四个参数，前两个表示图片左上角所在的cellNum和 rowNum，后两个参数对应的表示图片右下角所在的cellNum和 rowNum，
             * excel中的cellNum和rowNum的index都是从0开始的
             */
            //图片一导出到单元格B2中
            HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0,(short)colNum , rowNum, (short)(colNum+colspan), rowNum+rowspan);
            // 插入图片
            patriarch.createPicture(anchor, workbook.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_JPEG));
        }