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

2

How do I read a column of excel whose number is too large and prevent it from being interpreted as overflow?

In Excel, the column has the number 26468314801 . As a number it loads 2.6468314801E10 , I looked for the solution and some colleagues advised that I turn the column into text, but I can not control the end user.

How do I load correctly without this problem?

    
asked by anonymous 15.10.2015 / 18:58

1 answer

1

Marcelo,

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

    
30.01.2016 / 03:45