On Sun, 25 Apr 2010, Dave wrote:
But the Cell.setCellValue(...) has double type for numeric, it does not have method for BigDecimal, Long and Integer.
The excel file format only supports storing doubles. Excel doesn't support anything else.
If converting these types to double, it lost accuracy.
If you put them into excel by hand, it may show you a nicely formatted long or bigint, but it's really stored a double under the hood!
Nick
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
