使用poi导出时设置某个字段为外部超链接,例如打开百度

直接上代码:

/**
     * 导出
     *
     * @param policyQueryVo
     * @param headtitle
     * @return
     */
    public HSSFWorkbook findExcel(PolicyQueryVo policyQueryVo, String headtitle, String fieldName) {
        //获取要导出的内容
        List<PolicyQueryVo> policyQueryList = policyQueryDao.getPolicyQueryList(null, null, policyQueryVo);
        HSSFWorkbook workbook = new HSSFWorkbook();
        //创建表头单元格并添加相应的内容
        String[] cells = headtitle.split(",");
        //判断集合是否为空
        if (policyQueryList != null) {
            outputColums(cells, policyQueryList, workbook, fieldName);
        }
        return workbook;
    }

    /**
     * 设置每行数据
     *
     * @param headers
     * @param colums
     * @param hssfWorkbook
     */
    public static void outputColums(String[] headers, List<?> colums, HSSFWorkbook hssfWorkbook, String fieldName) {
        //声明一个sheet
        HSSFSheet sheet = hssfWorkbook.createSheet();
        //创建表头
        HSSFRow row = sheet.createRow(0);
        for (int i = 0; i < headers.length; i++) {
            HSSFCell cell = row.createCell(i);
            cell.setCellValue(headers[i]);
        }
        //循环多少行
        String[] fieldNames = fieldName.split(",");
        for (int i = 0; i < colums.size(); i++) {
            row = sheet.createRow(i + 1);
            //从rowIndex行开始创建行
            Object obj = colums.get(i);
            //循环多少列
            for (int j = 0; j < headers.length; j++) {
                Object value = getFieldValueByName(fieldNames[j], obj);
                if (fieldNames[j].equals("policyBtn")) {
                    HSSFCell cell = row.createCell(j);
                    cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
                    /**
                     * 这里使用Excle的HYPERLINK()函数,
                     * 函数的参数1:要访问的地址,参数2:展示Excle上的文字,
                     * 都需要用引号包含起来,所以这里用到了转义
                     */
                    cell.setCellFormula("HYPERLINK(" + ""https://www.baidu.com/"" + "," + ""下载")");
                    cell.setCellStyle(linkStyle(hssfWorkbook));
                } else if (value != null) {
                    row.createCell(j).setCellValue(value.toString());
                } else {
                    row.createCell(j).setCellValue("");
                }
            }
        }
    }

/**
     * 根据对象的属性获取值
     *
     * @param fieldName
     * @param obj
     * @return
     */
    private static Object getFieldValueByName(String fieldName, Object obj) {
        String firstLetter = fieldName.substring(0, 1).toUpperCase();
        String getter = "get" + firstLetter + fieldName.substring(1);
        try {
            Method method = obj.getClass().getMethod(getter, new Class[]{});
            Object value = method.invoke(obj, new Object[]{});
            return value;
        } catch (Exception e) {
            ////System.out.println("属性不存在");
            return null;
        }
    }

/**
     * 设置超链接等样式
     *
     * @param hssfWorkbook
     * @return
     */
    public static HSSFCellStyle linkStyle(HSSFWorkbook hssfWorkbook) {
        // 生成并设置另一个样式
        HSSFCellStyle linkStyle = hssfWorkbook.createCellStyle();
        //设置单元格边框
//        linkStyle.setBorderBottom((short) 1);
//        linkStyle.setBorderLeft((short) 1);
//        linkStyle.setBorderRight((short) 1);
//        linkStyle.setBorderTop((short) 1);
        //设置单元格背景颜色
//        linkStyle.setFillForegroundColor(HSSFColor.SKY_BLUE.index);
//        linkStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        HSSFFont font = hssfWorkbook.createFont();
        font.setFontName(HSSFFont.FONT_ARIAL);
        //设置字体下划线
        font.setUnderline((byte) 1);
        //设置字体颜色
        font.setColor(HSSFColor.BLUE.index);
        //设置字体
        linkStyle.setFont(font);
        // 生成另一个字体
//        font.setBoldweight(Font.BOLDWEIGHT_NORMAL);
        // 把字体应用到当前的样式
        linkStyle.setFont(font);
        return linkStyle;
    }