poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From noobguru <noobg...@gmail.com>
Subject RE: reading excel - can I get column format?
Date Mon, 22 Dec 2008 16:42:12 GMT

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 <noobguru@gmail.com> wrote:
> From: noobguru <noobguru@gmail.com>
> Subject: RE: reading excel - can I get column format?
> To: user@poi.apache.org
> 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:noobguru@gmail.com] 
> Sent: Friday, December 19, 2008 5:11 PM
> To: user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 
> 
>       
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message