poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <n...@torchbox.com>
Subject Re: XLSX2CSV example using XSSF Date Question
Date Tue, 19 May 2009 13:38:50 GMT
On Tue, 19 May 2009, Chris Lott wrote:
> The entry with numFmtId = 14 seems to be the style at index 1 that is 
> referenced by the cell with the date value.  Is this where the magic of 
> formatting dates is buried?  I sure don't see any local, custom format 
> string in that styles table entry.

org.apache.poi.ss.usermodel.BuiltinFormats is probably the one you're 
looking for here

> I tried calling DataFormatter#formatRawCellValue() passing it the 
> double, short number format index, and null format string.  Judging from 
> the null-pointer exceptions I'm seeing, the formatRawCellValue() method 
> needs a non-null format string.

Yup, I'd try it with the string you get back from BuiltinFormats for the 
ones where the Style Table doesn't have a custom one

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message