excel导入,解决数值型千分位逗号的问题
Double cellValue = cell.getNumericCellValue();
if (cellValue == null || cellValue - 0.0 < 1e-6) {
value = “0”;
} else {
value = new DecimalFormat(“0.00”).format(cellValue);
}
if (value.indexOf(“,”) >= 0) {
value = value.replaceAll(“,”, “”);
}