Julien, I am not quite sure what you are trying to do. But when you write a numeric value to an excel sheet, you have to set its type explicitly like:
HSFCell cell = row.createCell((short)0); cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); When you read it use: HSSFCell c0 = r0.getCell((short)0); int i = c0.getNumericCellValue(); regards, Ashlesha -----Original Message----- From: Julien Bittard [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 5:56 AM To: Poi-User Subject: Troubleshooting with number format Hello, In my web application, I created a Excel file with POI which contains Numeric cells. When I export this file in MS EXCel (2000 or 2003), there is a message on open : "Erreur de fichier. Certains formats de nombre ont peut-être été perdus." = Perhaps certain number formats were lost. Have you an idea ? thanks. --------------------------------------------------------------------- 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/
