I have such settings for recording information in a string.

XSSFColor baseBackgroungColor = new XSSFColor(Color.decode("#db6060")); XSSFCellStyle titleStyleRED = (XSSFCellStyle) wb.createCellStyle(); titleStyleRED.setFillForegroundColor(baseBackgroungColor); titleStyleRED.setFillPattern(CellStyle.SOLID_FOREGROUND); titleStyleRED.setBorderLeft(BorderStyle.THIN); titleStyleRED.setBorderRight(BorderStyle.THIN); titleStyleRED.setBorderTop(BorderStyle.THIN); titleStyleRED.setBorderBottom(BorderStyle.THIN);

in the end, my number 1,000,000 is recorded as 10,000,000; can it be made so that it is recorded as 1,000,000?

    1 answer 1

     DataFormat format = wb.createDataFormat(); titleStyleRED.setDataFormat(format.getFormat("### ### ### ###"));