Examples with CellExtra com.alibaba.excel.metadata.CellExtra used on opensource projects

Example 6 with CellExtra

use of com.alibaba.excel.metadata.CellExtra in project easyexcel by alibaba.

the class XlsxSaxAnalyser method readComments.

private void readComments(ReadSheet readSheet) {
    if (!xlsxReadContext.readWorkbookHolder().getExtraReadSet().contains(CellExtraTypeEnum.COMMENT)) {
        return;
    }
    CommentsTable commentsTable = commentsTableMap.get(readSheet.getSheetNo());
    if (commentsTable == null) {
        return;
    }
    Iterator<CellAddress> cellAddresses = commentsTable.getCellAddresses();
    while (cellAddresses.hasNext()) {
        CellAddress cellAddress = cellAddresses.next();
        XSSFComment cellComment = commentsTable.findCellComment(cellAddress);
        CellExtra cellExtra = new CellExtra(CellExtraTypeEnum.COMMENT, cellComment.getString().toString(), cellAddress.getRow(), cellAddress.getColumn());
        xlsxReadContext.readSheetHolder().setCellExtra(cellExtra);
        xlsxReadContext.analysisEventProcessor().extra(xlsxReadContext);
    }
}

Example 7 with CellExtra

use of com.alibaba.excel.metadata.CellExtra in project easyexcel by alibaba.

the class HyperlinkTagHandler method startElement.

@Override
public void startElement(XlsxReadContext xlsxReadContext, String name, Attributes attributes) {
    String ref = attributes.getValue(ExcelXmlConstants.ATTRIBUTE_REF);
    String location = attributes.getValue(ExcelXmlConstants.ATTRIBUTE_LOCATION);
    if (StringUtils.isEmpty(ref)) {
        return;
    }
    CellExtra cellExtra = new CellExtra(CellExtraTypeEnum.HYPERLINK, location, ref);
    xlsxReadContext.readSheetHolder().setCellExtra(cellExtra);
    xlsxReadContext.analysisEventProcessor().extra(xlsxReadContext);
}