Reading numeric value from Excel using Poi [duplicate]

Question

I am trying to read phone numbers from an excel file. The numbers written in the excel sheet are of format:

3211010101

Now when I use cell.getNumericCellValue() it gives a double with the format:

3.211010101E9

How can I covert this number to the format I require (the one in the excel file) or get the data in the correct format in the first place?

Furqan Tariq · Accepted Answer · 2015-08-15 15:20:48Z

0

Solved it using:

                        Double num = cell.getNumericCellValue();
                        DecimalFormat formatter = new DecimalFormat("#");
                        formatter.setMaximumFractionDigits(0);
                        String test = formatter.format(num);

answered Aug 15, 2015 at 15:20

Furqan Tariq

731 silver badge13 bronze badges

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

Collectives™ on Stack Overflow

Reading numeric value from Excel using Poi [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related