On Thu, Jun 17, 2010 at 2:41 AM, MSB <markbrd...@tiscali.co.uk> wrote:
> Anyway, at the risk of boring the pants off of you, there is really no such > thing as a date cell in Excel. What you see as a date is actually a > specially formatted number and so the call to getCellType() will tell you > that the cell is - quite rightly - a numeric one. As a result, there is a > method in the DateUtil class (org.apache.poi.ss.usermodel.DateUtil) that > will tell you whether the user has formatted the cell to look like a date. > As a result, when dealing attempting to work out what the cells contain, > most users of the API do something like this; > [snip] That is EXTREMELY helpful; thanks. Liking what I have seen so far in POI. Best, Laird
