少言少语

看文档 http://easypoi.mydoc.io/

步骤一

• 字段上面开启超链接

@Excel(name = "地址", isHyperlink = true)
private String path;

步骤二

• 实现拦截类

• 代码实现

public class ExcelDataHandler extends ExcelDataHandlerDefaultImpl<Object> {
    @Override
    public Hyperlink getHyperlink(CreationHelper creationHelper, Object obj, String name, Object value) {
        Hyperlink hyperlink = creationHelper.createHyperlink(HyperlinkType.URL);
        hyperlink.setLabel(name);
        hyperlink.setAddress((String) value);
        return hyperlink;
    }
}

Object为操作类

步骤三

• 将拦截类加载导出方法

ExportParams exportParams = new ExportParams(title, sheetName);
        exportParams.setDataHandler(new ExcelDataHandler());
        ExportExcelUtil.exportExcel(list, Object.class, fileName, response, exportParams);

Object操作模板

结束