RE: Getting Data type

2010-07-14 Thread MSB
quot;DOB" column is formatted as date. When the user uploads a file, I >> want to first check for the header data types in the first row. >> >> What I am expecting is that when I check the data type (ONLY THE > HEADER >> LABEL FIRST ROW) for User it returns String, First N

RE: Getting Data type

2010-07-14 Thread Kalpesh Modi
: user@poi.apache.org Subject: RE: Getting Data type I suspect that the reason the cell is being reported as type String is because POI is detecting a String in that cell. If you think back to my previous reply, I indicated that it is possible to enter one of three different types of data into a

RE: Getting Data type

2010-07-13 Thread MSB
eturns String, First Name returns String > and DOB also returns String. Actually I am expecting DOB to be Date. I > am not talking about the data type of the actual data from the second > row onwards. > > Thanks and regards, > -Kalpesh > > > -Original Message-

RE: Getting Data type

2010-07-13 Thread Kalpesh Modi
he second row onwards. Thanks and regards, -Kalpesh -Original Message- From: MSB [mailto:markbrd...@tiscali.co.uk] Sent: Tuesday, July 13, 2010 2:39 AM To: user@poi.apache.org Subject: Re: Getting Data type First some bad news; it is only possible to enter one of three different types

Re: Getting Data type

2010-07-12 Thread MSB
First some bad news; it is only possible to enter one of three different types of value into a cell, a number, a String or a forumla which is itslef a type of String I guess. Then you apply a format to that value to transform the cells content into a Date value a currency value, etc. Therefore, it