field set java_Java Field.setFloat方法代码示例

import java.lang.reflect.Field; //导入方法依赖的package包/类

private void getCellValue(Cell cell, Object o, Field field) throws IllegalAccessException, ParseException {

LOG.debug("cell:{}, field:{}, type:{}", cell.getCellTypeEnum(), field.getName(), field.getType().getName());

switch (cell.getCellTypeEnum()) {

case BLANK:

break;

case BOOLEAN:

field.setBoolean(o, cell.getBooleanCellValue());

break;

case ERROR:

field.setByte(o, cell.getErrorCellValue());

break;

case FORMULA:

field.set(o, cell.getCellFormula());

break;

case NUMERIC:

if (DateUtil.isCellDateFormatted(cell)) {

if (field.getType().getName().equals(Date.class.getName())) {

field.set(o, cell.getDateCellValue());

} else {

field.set(o, format.format(cell.getDateCellValue()));

}

} else {

if (field.getType().isAssignableFrom(Integer.class) || field.getType().getName().equals("int")) {

field.setInt(o, (int) cell.getNumericCellValue());

} else if (field.getType().isAssignableFrom(Short.class) || field.getType().getName().equals("short")) {

field.setShort(o, (short) cell.getNumericCellValue());

} else if (field.getType().isAssignableFrom(Float.class) || field.getType().getName().equals("float")) {

field.setFloat(o, (float) cell.getNumericCellValue());

} else if (field.getType().isAssignableFrom(Byte.class) || field.getType().getName().equals("byte")) {

field.setByte(o, (byte) cell.getNumericCellValue());

} else if (field.getType().isAssignableFrom(Double.class) || field.getType().getName().equals("double")) {

field.setDouble(o, cell.getNumericCellValue());

} else if (field.getType().isAssignableFrom(String.class)) {

String s = String.valueOf(cell.getNumericCellValue());

if (s.contains("E")) {

s = s.trim();

BigDecimal bigDecimal = new BigDecimal(s);

s = bigDecimal.toPlainString();

}

//防止整数判定为浮点数

if (s.endsWith(".0")) { s = s.substring(0, s.indexOf(".0")); }

field.set(o, s);

} else {

field.set(o, cell.getNumericCellValue());

}

}

break;

case STRING:

if (field.getType().getName().equals(Date.class.getName())) {

field.set(o, format.parse(cell.getRichStringCellValue().getString()));

} else {

field.set(o, cell.getRichStringCellValue().getString());

}

break;

default:

field.set(o, cell.getStringCellValue());

break;

}

}