Created attachment 33694 [details] XLSX containing numbers used as text When importing a number, it's value is listed with a decimal, ".0", on the end. This is not an issue when it is just a number as the decimal is stripped or ignored, but if it's meant to be text, it becomes an issue. Example file attached. This is noticed when importing a working using: Workbook workbook = new XSSFWorkbook(inputStream); Where inputStream is a ByteArrayInputStream of the file. It appears that the XML is correctly formatted: <row r="2" spans="1:1" x14ac:dyDescent="0.25"> <c r="A2" s="1"> <v>22103</v> </c> </row> However the value is not: workbook.getSheetAt(0).getRow(1).getCell(0).getNumericCellValue() = "22103.0"
getNumericCellValue returns a double, which will include a decimal point as per the Java Langauge spec If you want a string of what your cell looks like in Excel, try DataFormatter.