easyexcel 添加超链接


easyexcel 添加超链接

 

 

***********************

相关类与接口

 

AbstractCellWriteHandler

public abstract class AbstractCellWriteHandler implements CellWriteHandler {

    @Override
    public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row,
        Head head, Integer columnIndex, Integer relativeRowIndex, Boolean isHead) {

    }

    @Override
    public void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell,
        Head head, Integer relativeRowIndex, Boolean isHead) {

    }

    @Override
    public void afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder,
        CellData cellData, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {

    }

    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder,
        List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {

    }
}

 

CellWriteHandler

public interface CellWriteHandler extends WriteHandler {

    void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head,
        Integer columnIndex, Integer relativeRowIndex, Boolean isHead);

    void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell, Head head,
        Integer relativeRowIndex, Boolean isHead);

    void afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, CellData cellData,
        Cell cell, Head head, Integer relativeRowIndex, Boolean isHead);

    void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder,
        List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead);
}

 

WriteHandler

public interface WriteHandler extends Handler {
}

 

Handler

public interface Handler {
}

 

 

Cell

public interface Cell {

    int getColumnIndex();
    int getRowIndex();

    Sheet getSheet();
    Row getRow();

    void setCellType(CellType var1);
    void setCellStyle(CellStyle var1);


    @Removal(version = "4.2")
    CellType getCellTypeEnum();

    CellStyle getCellStyle();


    void setCellValue(double var1);
    void setCellValue(RichTextString var1);
    void setCellValue(String var1);
    void setCellValue(boolean var1);
    void setCellValue(Date var1);
    void setCellValue(Calendar var1);
    void setCellErrorValue(byte var1);
    void setCellFormula(String var1) throws FormulaParseException;

    double getNumericCellValue();
    RichTextString getRichStringCellValue();
    String getStringCellValue();
    boolean getBooleanCellValue();
    Date getDateCellValue();
    byte getErrorCellValue();
    String getCellFormula();


    void setAsActiveCell();
    CellAddress getAddress();

    void setCellComment(Comment var1);
    Comment getCellComment();
    void removeCellComment();

    Hyperlink getHyperlink();
    void setHyperlink(Hyperlink var1);
    void removeHyperlink();

    CellRangeAddress getArrayFormulaRange();
    boolean isPartOfArrayFormulaGroup();

    CellType getCachedFormulaResultTypeEnum();
}

 

CreationHelper

public interface CreationHelper {

    RichTextString createRichTextString(String var1);
    DataFormat createDataFormat();

    Hyperlink createHyperlink(HyperlinkType var1);    //创建超链接

    FormulaEvaluator createFormulaEvaluator();

    ExtendedColor createExtendedColor();

    ClientAnchor createClientAnchor();

    AreaReference createAreaReference(String var1);
    AreaReference createAreaReference(CellReference var1, CellReference var2);
}

 

HyperLinkType

public enum HyperlinkType {
    @Internal
    NONE(-1),
    URL(1),
    DOCUMENT(2),
    EMAIL(3),
    FILE(4);

 

 

***********************

示例

 

Test

@Data
class Student{

    private Integer id;
    private String name;
    private Integer age;
}

class CustomCellWriteHandler extends AbstractCellWriteHandler{

    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, List<CellData> cellDataList, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {
        if (cell.getRowIndex()==2&&cell.getColumnIndex()==1){
                             //第2行、第1列添加超链接(从0开始)

            CreationHelper helper=writeSheetHolder.getSheet().getWorkbook().getCreationHelper();
            Hyperlink hyperlink=helper.createHyperlink(HyperlinkType.URL);
            hyperlink.setAddress("http://www.baidu.com");
            cell.setHyperlink(hyperlink);
        }
    }
}

public class Test8 {

    private static final String write_path="e:"+ File.separator+"java"+File.separator+"easyexcel"+File.separator+"write3.xlsx";

    public static void main(String[] args){
        List<Student> list=new ArrayList<>();

        for (int i=0;i<5;i++){
            Student student=new Student();
            student.setId(i);
            student.setName("瓜田李下 "+i);
            student.setAge(20+i);

            list.add(student);
        }

        EasyExcel.write(write_path,Student.class)
                .registerWriteHandler(new CustomCellWriteHandler())
                .sheet().doWrite(list);
    }
}

 

*****************

使用测试

 

                         

 

点击超链接、跳转到百度首页

               

 

 

  • 1
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 3
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值