private static String getCellStringValueWithNumberType ( final Cell poiCell ) { String result ; if ( DateUtil . isCellDateFormatted ( poiCell ) ) { result = poiCell . getDateCellValue ( ) . toString ( ) ; } else { result = BigDecimal . valueOf ( poiCell . getNumericCellValue ( ) ) . toPlainString ( ) ; // remove .0 from end for int if ( result . endsWith ( ".0" ) ) { result = result . substring ( 0 , result . length ( ) - 2 ) ; } } return result ; }
Gets the cell string value with number type .