Examples with WriteCellData com.alibaba.excel.metadata.data.WriteCellData used on opensource projects

Example 6 with WriteCellData

use of com.alibaba.excel.metadata.data.WriteCellData in project easyexcel by alibaba.

the class AbstractExcelWriteExecutor method doConvert.

private WriteCellData<?> doConvert(CellWriteHandlerContext cellWriteHandlerContext) {
    ExcelContentProperty excelContentProperty = cellWriteHandlerContext.getExcelContentProperty();
    Converter<?> converter = null;
    if (excelContentProperty != null) {
        converter = excelContentProperty.getConverter();
    }
    if (converter == null) {
        // csv is converted to string by default
        if (writeContext.writeWorkbookHolder().getExcelType() == ExcelTypeEnum.CSV) {
            cellWriteHandlerContext.setTargetCellDataType(CellDataTypeEnum.STRING);
        }
        converter = writeContext.currentWriteHolder().converterMap().get(ConverterKeyBuild.buildKey(cellWriteHandlerContext.getOriginalFieldClass(), cellWriteHandlerContext.getTargetCellDataType()));
    }
    if (cellWriteHandlerContext.getOriginalValue() == null && !(converter instanceof NullableObjectConverter)) {
        return new WriteCellData<>(CellDataTypeEnum.EMPTY);
    }
    if (converter == null) {
        throw new ExcelWriteDataConvertException(cellWriteHandlerContext, "Can not find 'Converter' support class " + cellWriteHandlerContext.getOriginalFieldClass().getSimpleName() + ".");
    }
    WriteCellData<?> cellData;
    try {
        cellData = ((Converter<Object>) converter).convertToExcelData(new WriteConverterContext<>(cellWriteHandlerContext.getOriginalValue(), excelContentProperty, writeContext));
    } catch (Exception e) {
        throw new ExcelWriteDataConvertException(cellWriteHandlerContext, "Convert data:" + cellWriteHandlerContext.getOriginalValue() + " error, at row:" + cellWriteHandlerContext.getRowIndex(), e);
    }
    if (cellData == null || cellData.getType() == null) {
        throw new ExcelWriteDataConvertException(cellWriteHandlerContext, "Convert data:" + cellWriteHandlerContext.getOriginalValue() + " return is null or return type is null, at row:" + cellWriteHandlerContext.getRowIndex());
    }
    return cellData;
}

Example 7 with WriteCellData

use of com.alibaba.excel.metadata.data.WriteCellData in project RuoYi-Vue-Plus by JavaLionLi.

the class ExcelDictConvert method convertToExcelData.

@Override
public WriteCellData<String> convertToExcelData(Object object, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
    if (ObjectUtil.isNull(object)) {
        return new WriteCellData<>("");
    }
    ExcelDictFormat anno = getAnnotation(contentProperty.getField());
    String type = anno.dictType();
    String value = Convert.toStr(object);
    String label;
    if (StringUtils.isBlank(type)) {
        label = ExcelUtil.convertByExp(value, anno.readConverterExp(), anno.separator());
    } else {
        label = SpringUtils.getBean(DictService.class).getDictLabel(type, value, anno.separator());
    }
    return new WriteCellData<>(label);
}

Example 8 with WriteCellData

use of com.alibaba.excel.metadata.data.WriteCellData in project RuoYi-Cloud-Plus by JavaLionLi.

the class ExcelBigNumberConvert method convertToExcelData.

@Override
public WriteCellData<Object> convertToExcelData(Long object, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
    if (ObjectUtil.isNotNull(object)) {
        String str = Convert.toStr(object);
        if (str.length() > 15) {
            return new WriteCellData<>(str);
        }
    }
    WriteCellData<Object> cellData = new WriteCellData<>(new BigDecimal(object));
    cellData.setType(CellDataTypeEnum.NUMBER);
    return cellData;
}

Example 9 with WriteCellData

use of com.alibaba.excel.metadata.data.WriteCellData in project RuoYi-Cloud-Plus by JavaLionLi.

the class ExcelDictConvert method convertToExcelData.

@Override
public WriteCellData<String> convertToExcelData(Object object, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
    if (ObjectUtil.isNull(object)) {
        return new WriteCellData<>("");
    }
    ExcelDictFormat anno = getAnnotation(contentProperty.getField());
    String type = anno.dictType();
    String value = Convert.toStr(object);
    String label;
    if (StringUtils.isBlank(type)) {
        label = ExcelUtil.convertByExp(value, anno.readConverterExp(), anno.separator());
    } else {
        label = SpringUtils.getBean(DictService.class).getDictLabel(type, value, anno.separator());
    }
    return new WriteCellData<>(label);
}

Example 10 with WriteCellData

use of com.alibaba.excel.metadata.data.WriteCellData in project RuoYi-Vue-Plus by JavaLionLi.

the class ExcelBigNumberConvert method convertToExcelData.

@Override
public WriteCellData<Object> convertToExcelData(Long object, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
    if (ObjectUtil.isNotNull(object)) {
        String str = Convert.toStr(object);
        if (str.length() > 15) {
            return new WriteCellData<>(str);
        }
    }
    WriteCellData<Object> cellData = new WriteCellData<>(new BigDecimal(object));
    cellData.setType(CellDataTypeEnum.NUMBER);
    return cellData;
}