Forgive me asking this as I am a couple of version behind at the moment but did you set the format of the column using HSSF or Excel?
--- On Mon, 12/22/08, noobguru <[email protected]> wrote: From: noobguru <[email protected]> Subject: RE: reading excel - can I get column format? To: [email protected] Date: Monday, December 22, 2008, 7:50 AM Thanks Joe, But I formatted the entire column to one format. So is there anyway to get that format? noobguru HSSFCell cell = ci.next(); if (cell.getCellType() == cell.CELL_TYPE_STRING) s = s+cell.getRichStringCellValue(); -----Original Message----- From: noobguru [mailto:[email protected]] Sent: Friday, December 19, 2008 5:11 PM To: [email protected] Subject: reading excel - can I get column format? I've tried looking in the apache poi documentation as well as this forum, however, I couldn't find if it was possible to get the format of a column in a 2007 excel file. Is this possible at all? (e.g. whether a column is a Number, String, Date, etc). If this is not possible, is there a way to get the format of a cell that has no data in it? (e.g. whether this cell is formatted as a Number, String, Date, etc). Thanks in advance! ~noobguru -- View this message in context: http://www.nabble.com/reading-excel---can-I-get-column-format--tp2109903 1p21099031.html Sent from the POI - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/reading-excel---can-I-get-column-format--tp21099031p21129971.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
