Java Code Examples for com.alibaba.excel.metadata.CellData#getStringValue()

The following examples show how to use com.alibaba.excel.metadata.CellData#getStringValue() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: EnumExcelConverter.java    From easyexcel-utils with Apache License 2.0 6 votes vote down vote up
@Override
public Enum convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
    String cellDataStr = cellData.getStringValue();

    EnumFormat annotation = contentProperty.getField().getAnnotation(EnumFormat.class);
    Class enumClazz = annotation.value();
    String[] fromExcel = annotation.fromExcel();
    String[] toJavaEnum = annotation.toJavaEnum();

    Enum anEnum = null;
    if (ArrayUtils.isNotEmpty(fromExcel) && ArrayUtils.isNotEmpty(toJavaEnum)) {
        Assert.isTrue(fromExcel.length == toJavaEnum.length, "fromExcel 与 toJavaEnum 的长度必须相同");
        for (int i = 0; i < fromExcel.length; i++) {
            if (Objects.equals(fromExcel[i], cellDataStr)) {
                anEnum = EnumUtils.getEnum(enumClazz, toJavaEnum[i]);
            }
        }
    } else {
        anEnum = EnumUtils.getEnum(enumClazz, cellDataStr);
    }

    Assert.notNull(anEnum, "枚举值不合法");
    return anEnum;
}
 
Example 2
Source File: DisabledConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (ENABLE.equals(stringValue.trim())){
        return 0;
    }else {
        return 1;
    }
}
 
Example 3
Source File: DeleteConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (DELETE.equals(stringValue)){
        return 1;
    }else {
        return 0;
    }
}
 
Example 4
Source File: DisabledConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (ENABLE.equals(stringValue.trim())){
        return 0;
    }else {
        return 1;
    }
}
 
Example 5
Source File: DeleteConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (DELETE.equals(stringValue)){
        return 1;
    }else {
        return 0;
    }
}
 
Example 6
Source File: DisabledConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (ENABLE.equals(stringValue.trim())){
        return 0;
    }else {
        return 1;
    }
}
 
Example 7
Source File: DeleteConverter.java    From fw-spring-cloud with Apache License 2.0 5 votes vote down vote up
@Override
public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    String stringValue = cellData.getStringValue();
    if (DELETE.equals(stringValue)){
        return 1;
    }else {
        return 0;
    }
}
 
Example 8
Source File: CellInlineStringValueTagHandler.java    From easyexcel with Apache License 2.0 5 votes vote down vote up
@Override
protected void setStringValue(XlsxReadContext xlsxReadContext) {
    // This is a special form of string
    CellData tempCellData = xlsxReadContext.xlsxReadSheetHolder().getTempCellData();
    XSSFRichTextString richTextString = new XSSFRichTextString(tempCellData.getStringValue());
    tempCellData.setStringValue(richTextString.toString());
}
 
Example 9
Source File: AbstractCellValueTagHandler.java    From easyexcel with Apache License 2.0 5 votes vote down vote up
@Override
public void endElement(XlsxReadContext xlsxReadContext, String name) {
    XlsxReadSheetHolder xlsxReadSheetHolder = xlsxReadContext.xlsxReadSheetHolder();
    CellData tempCellData = xlsxReadSheetHolder.getTempCellData();
    StringBuilder tempData = xlsxReadSheetHolder.getTempData();
    CellDataTypeEnum oldType = tempCellData.getType();
    switch (oldType) {
        case DIRECT_STRING:
        case STRING:
        case ERROR:
            tempCellData.setStringValue(tempData.toString());
            break;
        case BOOLEAN:
            tempCellData.setBooleanValue(BooleanUtils.valueOf(tempData.toString()));
            break;
        case NUMBER:
        case EMPTY:
            tempCellData.setType(CellDataTypeEnum.NUMBER);
            tempCellData.setNumberValue(new BigDecimal(tempData.toString()));
            break;
        default:
            throw new IllegalStateException("Cannot set values now");
    }

    // set string value
    setStringValue(xlsxReadContext);

    if (tempCellData.getStringValue() != null
        && xlsxReadContext.currentReadHolder().globalConfiguration().getAutoTrim()) {
        tempCellData.setStringValue(tempCellData.getStringValue());
    }

    tempCellData.checkEmpty();
    xlsxReadSheetHolder.getCellMap().put(xlsxReadSheetHolder.getColumnIndex(), tempCellData);
}
 
Example 10
Source File: StringStringConverter.java    From easyexcel with Apache License 2.0 4 votes vote down vote up
@Override
public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty,
    GlobalConfiguration globalConfiguration) {
    return cellData.getStringValue();
}
 
Example 11
Source File: StringErrorConverter.java    From easyexcel with Apache License 2.0 4 votes vote down vote up
@Override
public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty,
    GlobalConfiguration globalConfiguration) {
    return cellData.getStringValue();
}
 
Example 12
Source File: CustomStringStringConverter.java    From easyexcel with Apache License 2.0 2 votes vote down vote up
/**
 * 这里是读的时候会调用 不用管
 *
 * @param cellData
 *            NotNull
 * @param contentProperty
 *            Nullable
 * @param globalConfiguration
 *            NotNull
 * @return
 */
@Override
public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty,
    GlobalConfiguration globalConfiguration) {
    return cellData.getStringValue();
}
 
Example 13
Source File: CustomStringStringConverter.java    From easyexcel with Apache License 2.0 2 votes vote down vote up
/**
 * 这里读的时候会调用
 *
 * @param cellData
 *            NotNull
 * @param contentProperty
 *            Nullable
 * @param globalConfiguration
 *            NotNull
 * @return
 */
@Override
public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty,
    GlobalConfiguration globalConfiguration) {
    return "自定义:" + cellData.getStringValue();
}