How to output the number from Excel as a String in java?

Question

This is my code, which reading from excell file and insert to database, but when I insert to database numeric type from excell, it looks like this 9.94775287264E11, but I want to store this data like this 994775287264. This number value in excell store like this 994775287264

public static Response acceptFile(File file) {
        try {
            String phoneNumber = "";
            String textMessage = "";
            FileInputStream excelFile = new FileInputStream(file);
            Workbook workbook = new XSSFWorkbook(excelFile);
            Sheet datatypeSheet = workbook.getSheetAt(0);
            Iterator<Row> iterator = datatypeSheet.iterator();
            while (iterator.hasNext()) {

                Row currentRow = iterator.next();
                Iterator<Cell> cellIterator = currentRow.iterator();

                while (cellIterator.hasNext()) {

                    Cell currentCell = cellIterator.next();
                    //getCellTypeEnum shown as deprecated for version 3.15
                    //getCellTypeEnum ill be renamed to getCellType starting from version 4.0
                    if (currentCell.getCellTypeEnum() == CellType.STRING) {
                        phoneNumber = String.valueOf(currentCell.getStringCellValue());
                    } else if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
                        textMessage = String.valueOf(currentCell.getNumericCellValue());
                    }

                }

            }
            insertExcellFileToDb(phoneNumber, textMessage);
            System.out.println(phoneNumber + " " + textMessage);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return null;
    }

How are you effectively storing the data in the database? In the snipped you provided both phoneNumber and textMessage are strings, but somewhere they are being converted to numbers. Maybe in insertExcellFileToDb? — Picoral
– Picoral, Commented Oct 13, 2021 at 20:58
@Picoral in my database phone_column type String, so I just want to store it as true way, not only weird. — iwritecomeinmymind
– iwritecomeinmymind, Commented Oct 13, 2021 at 21:13
I solved already which using the following code phoneNumber = NumberToTextConverter.toText(currentCell.getNumericCellValue()); — iwritecomeinmymind
– iwritecomeinmymind, Commented Oct 13, 2021 at 21:23

JW Geertsma · Accepted Answer · 2021-10-15 08:47:43Z

1

I solved the problem. I've change the code to the following code:

if (currentCell.getCellTypeEnum() == CellType.NUMERIC) {
   phoneNumber = NumberToTextConverter.toText(currentCell.getNumericCellValue());
} else if (currentCell.getCellTypeEnum() == CellType.STRING) {
   textMessage = String.valueOf(currentCell.getStringCellValue());
}

edited Oct 15, 2021 at 8:47

JW Geertsma

8753 gold badges18 silver badges22 bronze badges

answered Oct 15, 2021 at 7:17

iwritecomeinmymind

3861 gold badge5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to output the number from Excel as a String in java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related