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

Example 16 with Head

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

the class AbstractWriteHolder method initAnnotationConfig.

protected void initAnnotationConfig(List<WriteHandler> handlerList, WriteBasicParameter writeBasicParameter) {
    if (!HeadKindEnum.CLASS.equals(getExcelWriteHeadProperty().getHeadKind())) {
        return;
    }
    if (writeBasicParameter.getClazz() == null) {
        return;
    }
    Map<Integer, Head> headMap = getExcelWriteHeadProperty().getHeadMap();
    boolean hasColumnWidth = false;
    for (Head head : headMap.values()) {
        if (head.getColumnWidthProperty() != null) {
            hasColumnWidth = true;
        }
        dealLoopMerge(handlerList, head);
    }
    if (hasColumnWidth) {
        dealColumnWidth(handlerList);
    }
    dealStyle(handlerList);
    dealRowHigh(handlerList);
    dealOnceAbsoluteMerge(handlerList);
}

Example 17 with Head

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

the class WriteContextImpl method addOneRowOfHeadDataToExcel.

private void addOneRowOfHeadDataToExcel(Row row, Integer rowIndex, Map<Integer, Head> headMap, int relativeRowIndex) {
    for (Map.Entry<Integer, Head> entry : headMap.entrySet()) {
        Head head = entry.getValue();
        int columnIndex = entry.getKey();
        ExcelContentProperty excelContentProperty = ClassUtils.declaredExcelContentProperty(null, currentWriteHolder.excelWriteHeadProperty().getHeadClazz(), head.getFieldName());
        CellWriteHandlerContext cellWriteHandlerContext = WriteHandlerUtils.createCellWriteHandlerContext(this, row, rowIndex, head, columnIndex, relativeRowIndex, Boolean.TRUE, excelContentProperty);
        WriteHandlerUtils.beforeCellCreate(cellWriteHandlerContext);
        Cell cell = row.createCell(columnIndex);
        cellWriteHandlerContext.setCell(cell);
        WriteHandlerUtils.afterCellCreate(cellWriteHandlerContext);
        WriteCellData<String> writeCellData = new WriteCellData<>(head.getHeadNameList().get(relativeRowIndex));
        cell.setCellValue(writeCellData.getStringValue());
        cellWriteHandlerContext.setCellDataList(ListUtils.newArrayList(writeCellData));
        cellWriteHandlerContext.setFirstCellData(writeCellData);
        WriteHandlerUtils.afterCellDispose(cellWriteHandlerContext);
    }
}

Example 18 with Head

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

the class ExcelHeadProperty method initOneColumnProperty.

/**
 * Initialization column property
 *
 * @param index
 * @param field
 * @param forceIndex
 * @return Ignore current field
 */
private void initOneColumnProperty(int index, Field field, Boolean forceIndex) {
    ExcelProperty excelProperty = field.getAnnotation(ExcelProperty.class);
    List<String> tmpHeadList = new ArrayList<String>();
    String fieldName = FieldUtils.resolveCglibFieldName(field);
    boolean notForceName = excelProperty == null || excelProperty.value().length <= 0 || (excelProperty.value().length == 1 && StringUtils.isEmpty((excelProperty.value())[0]));
    if (headMap.containsKey(index)) {
        tmpHeadList.addAll(headMap.get(index).getHeadNameList());
    } else {
        if (notForceName) {
            tmpHeadList.add(fieldName);
        } else {
            Collections.addAll(tmpHeadList, excelProperty.value());
        }
    }
    Head head = new Head(index, field, fieldName, tmpHeadList, forceIndex, !notForceName);
    headMap.put(index, head);
}

Example 19 with Head

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

the class StyleDataTest method t04AbstractVerticalCellStyleStrategy02.

@Test
public void t04AbstractVerticalCellStyleStrategy02() {
    final StyleProperty styleProperty = StyleProperty.build(StyleData.class.getAnnotation(HeadStyle.class));
    final FontProperty fontProperty = FontProperty.build(StyleData.class.getAnnotation(HeadFontStyle.class));
    AbstractVerticalCellStyleStrategy verticalCellStyleStrategy = new AbstractVerticalCellStyleStrategy() {

        @Override
        protected WriteCellStyle headCellStyle(Head head) {
            WriteCellStyle writeCellStyle = WriteCellStyle.build(styleProperty, fontProperty);
            if (head.getColumnIndex() == 0) {
                writeCellStyle.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
                WriteFont writeFont = new WriteFont();
                writeFont.setItalic(true);
                writeFont.setStrikeout(true);
                writeFont.setTypeOffset(Font.SS_NONE);
                writeFont.setUnderline(Font.U_DOUBLE);
                writeFont.setBold(true);
                writeFont.setCharset((int) Font.DEFAULT_CHARSET);
            } else {
                writeCellStyle.setFillForegroundColor(IndexedColors.BLUE.getIndex());
            }
            return writeCellStyle;
        }

        @Override
        protected WriteCellStyle contentCellStyle(Head head) {
            WriteCellStyle writeCellStyle = new WriteCellStyle();
            writeCellStyle.setFillPatternType(FillPatternType.SOLID_FOREGROUND);
            if (head.getColumnIndex() == 0) {
                writeCellStyle.setFillForegroundColor(IndexedColors.DARK_GREEN.getIndex());
            } else {
                writeCellStyle.setFillForegroundColor(IndexedColors.PINK.getIndex());
            }
            return writeCellStyle;
        }
    };
    EasyExcel.write(fileVerticalCellStyleStrategy207, StyleData.class).registerWriteHandler(verticalCellStyleStrategy).sheet().doWrite(data());
}