Hi Nick, I am looking for org.apache.poi.hssf.usermodel.HSSFDataFormatter in poi 3.1 We couldn't find it in the release 3.1 jar.
Has it been removed? Thanks, ----- Original Message ---- From: Anthony Andrews <[EMAIL PROTECTED]> To: POI Users List <[email protected]> Sent: Thursday, October 16, 2008 8:53:07 PM Subject: Re: How to get cell value general type as it is? Have downloaded 3.1 FINAL from the Apache website and cannot find the HSSFDataFormatter class either in the archive or listed in the javadocs for the release. Yet the change-log indicates that it 'ought' to be there. The only thing I could think that you might do is to ask Nick. --- On Wed, 10/15/08, geek.shrek <[EMAIL PROTECTED]> wrote: From: geek.shrek <[EMAIL PROTECTED]> Subject: Re: How to get cell value general type as it is? To: "POI Users List" <[email protected]>, [EMAIL PROTECTED] Date: Wednesday, October 15, 2008, 3:09 PM Thanks Anthony, I saw it in API, but I couldn't find it anywhere in the poi jar (neither poi-3.1 or contrib or scratchpad). How did you use this class? Thanks, ----- Original Message ---- From: Anthony Andrews <[EMAIL PROTECTED]> To: POI Users List <[email protected]> Sent: Wednesday, October 15, 2008 6:03:57 PM Subject: Re: How to get cell value general type as it is? Sorry to say that I am not at my PC so do not have any code to hand to demonstrate but I would advise you to take a look at the HSSFDataFormatter class. Most likely, you will want to use one of the formatCellValue() methods. --- On Tue, 10/14/08, geek.shrek <[EMAIL PROTECTED]> wrote: From: geek.shrek <[EMAIL PROTECTED]> Subject: How to get cell value general type as it is? To: [email protected] Date: Tuesday, October 14, 2008, 8:18 PM Hi, I wonder how can I have the cell value just the way it is? For example if I have the whole worksheet as general type and the cell value for example "2" or "1234", if I get it as a string it will become "2.0" or "1234.0" I need to get the cell value just like the user type on it. For example if the user typed "2" i will get "2" instead of 2.0 and if the user type "2.0" i will get "2.0" I also try to set my xls as "text type" but it still adding ".0" at the end. Is it possible to have the number just the way I see it in xls? I hope I explain my problem clearly. Thanks,
