What to do to read a column in excel with very large numbers?

Asked

Viewed 314 times

2

How to do for when reading an excel column whose number is too large and prevent it from being interpreted overflowing?

In Excel the column is with the number 26468314801. How is a number he carries 2.6468314801E10 , I looked for the solution and some colleagues advised to turn the column into text, but I have no way to control the end user.

How do I get it to load correctly without this problem?

java-ee apache-poi

1 answer

1


Marcelo,

Transform the cell as follows: new BigDecimal(cell.getNumericCellValue())), or utilize DecimalFormat.

Browser other questions tagged java-ee apache-poi

You are not signed in. Login or sign up in order to post.