I set the columns in the excel file using Excel. Now I'm trying to read those formats from the excel file using the libraries given so that I take a text file (with data in it) and place it in the appropriate columns.
Anthony Andrews wrote: > > 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] > > > > > > -- View this message in context: http://www.nabble.com/reading-excel---can-I-get-column-format--tp21099031p21130846.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]
