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,
