Thanks for help. I formatted as "0.00" but when I check value in excel file value in cell is: 49,4700012207031 The value I want here is: 49,47 Any way to solve it ?
On 01/11/05, Amol Deshmukh <[EMAIL PROTECTED]> wrote: > > Carlos, > > There is no integer "datatype" for excel, all numeric > values are stored as doubles. I suspect your problem > may have something to do with the cell format. > > These may help you: > > http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFData > Format.html > > http://jakarta.apache.org/poi/hssf/quick-guide.html#DataFormats > > ~ amol > > > > -----Original Message----- > > From: Carlos Bergueira [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, November 01, 2005 11:33 AM > > To: POI Users List > > Subject: Float value into Cell > > > > > > Hi All, > > > > I really need to put a float value into a cell. > > > > This is what I have done: > > > > > > > > HSSFRow row = sheet.createRow( (short) currentNoOfExcelRows); > > > > HSSFCell debit = row.createCell( (short) 1); > > HSSFCell credit = row.createCell( (short) 2); > > > > debit.setCellValue(account.getDebit()); // get the debit from > > database where > > datatype is float > > credit.setCellValue(account.getCredit()); // get the credit > > from database > > where datatype is float > > > > > > > > > > The result is an integer value ! > > Help is appreciated. > > Thanks. > > > > -- > > Cumprts, > > Carlos Bergueira > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > -- Cumprts, Carlos Bergueira
