This will probably do the trick. NumberFormat percent = NumberFormat.getPercentInstance(); System.out.println(percent.format(cell.getNumericCellValue()));
Eric On Fri, 2004-01-23 at 08:31, [EMAIL PROTECTED] wrote: > Hello all. > I'm new in POI, so sorry for maybe a silly question. > I'm using HSSF API to read xls files and to construct my objects. > But I don't know how to manage cell formatting which is used in Excell. > For example: > I have a cell value in Excel - "95%" this is a numeric field with > "percent formatting". > When I apply cell.getNumericCellValue() I receive 0.95. I guess it's OK. > Then I use cell.getCellStyle().getDataFormat() and receive "0%" which is > also OK. > But I didn't find how to receive a result(in String format, maybe) with > value "95%". > Is there any way in POI to construct such a string having value(0.95) and > dataType(0%)??? > I've found 2 NumberFormatter classes, but I don't know how to use them, > the is absolutely no documentation > and while tryng NumberFormatter,format(99,1) I receive an error : 99 index > out of bounds. > > Thanks in advance. -- Eric Ladner <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
