Java: reading numeric value from a field as string is showing with decimals

Question

I have a field in the input xlsx file which can contain either email or mobile number. While reading it, I am having the following logic -

Workbook workbook = WorkbookFactory.create(new File("./TXN_Log_Mar_18_input.xlsx"));
Sheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = sheet.rowIterator();
while (rowIterator.hasNext() && cnt <maxRows) {
    System.out.println("\n\nNew row "+cnt+" ");
    Row row = rowIterator.next();
    if(row.getCell(11).toString() !="" || row.getCell(12).toString() !="")
    {

        String debitUser = row.getCell(11).toString();
        System.out.println("input mobile? "+debitUser);
        if(emailFormat(debitUser) || mobileFormat(debitUser))
        {
            response  = umCall(debitUser);
        }   

    }
}

With a proper 10 digit mobile number, following is the output -

input mobile? 7.358681129E9

Try using DataFormatter as shown in Getting the cell contents. DataFormatter formatter = new DataFormatter(); ... String debitUser = formatter.formatCellValue(row.getCell(11)); — Axel Richter
– Axel Richter, Commented May 25, 2018 at 7:46

lohnns · Accepted Answer · 2018-05-24 21:23:48Z

1

I assume you are using Apache POI, so I recommend you to not use toString() method. Use getCellValue() methods instead.

If you know the type of the value contained by your cell, you can use specific method like getNumericCellValue() that returns a double. Then it is up to you to format data as you wish.

double cellValue = row.getCell(11).getNumericCellValue();
System.out.println("input mobile? " + (int) cellValue);

Something like that maybe.

See Cell documentation to find the best way to do.

https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html

Also I recommend you to check the type of your cell before dealing with data.

answered May 24, 2018 at 21:23

lohnns

1731 gold badge2 silver badges8 bronze badges

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

1 Comment

lohnns Over a year ago

To test cell type, you can use getCellType() and compare to CellType.NUMERIC.

Steve11235 · Accepted Answer · 2018-05-24 21:04:02Z

0

I can't see the type returned by getCell(), but I'm guessing it is a BigDecimal, or something very similar. BigDecimal has toPlainString(), which prevents formatting large numbers using exponential notation. Whatever the type returned, look at its methods for something similar.

answered May 24, 2018 at 21:04

Steve11235

2,9412 gold badges20 silver badges20 bronze badges

1 Comment

lohnns Over a year ago

Here the java doc for Row class: poi.apache.org/apidocs/org/apache/poi/ss/usermodel/…

Collectives™ on Stack Overflow

Java: reading numeric value from a field as string is showing with decimals

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related