On 12/11/2013 11:12 PM, Nick Burch wrote:
On Wed, 11 Dec 2013, Aram Mirzadeh wrote:
The first 15 rows (all columns), the text of the cell is replaced
with a numeric value, it's the same value each time but I can't
figure out where it's coming from.
Commenting out the cell.setCellType(Cell.CELL_TYPE_NUMERIC); does
indeed fix the problem.
Why are you calling setCellType(Cell.CELL_TYPE_NUMERIC) on the cells?
Generally this isn't needed - if reading you want the type the cell
already has, if writing you normally let POI set the type when you set
the value
Nick
I'm writing, but POI is setting some of them to general when they are in
fact numeric. But either way the resulting behavior isn't expected right?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]