poi 默认2位小数_poi 带小数点读成浮点精度解决

if (CellType.NUMERIC.getCode() == (cellType)) {

cellValue = realStringValueOfDouble(cell.getNumericCellValue());

} else {

cell.setCellType(CellType.STRING);

cellValue = cell.getStringCellValue();

}

public static String realStringValueOfDouble(Double d) {

String doubleStr = d.toString();

boolean b = doubleStr.contains("E");

int indexOfPoint = doubleStr.indexOf('.');

if (b) {

int indexOfE = doubleStr.indexOf('E');

BigInteger xs = new BigInteger(doubleStr.substring(indexOfPoint + BigInteger.ONE.intValue(), indexOfE));

int pow = Integer.parseInt(doubleStr.substring(indexOfE + BigInteger.ONE.intValue()));

int xsLen = xs.toByteArray().length;

int scale = xsLen - pow > 0 ? xsLen - pow : 0;

final String format = "%." + scale + "f";

doubleStr = String.format(format, d);

} else {

java.util.regex.Pattern p = Pattern.compile(".0$");

java.util.regex.Matcher m = p.matcher(doubleStr);

if (m.find()) {

doubleStr = doubleStr.replace(".0", "");

}

}

return doubleStr;