Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <21130946.post@talk.nabble.com>
Date: Mon, 22 Dec 2008 08:48:09 -0800 (PST)
From: noobguru <noobguru@gmail.com>
To: user@poi.apache.org
Subject: RE: reading excel - can I get column format?
In-Reply-To: <21130846.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <21099031.post@talk.nabble.com>
 <A955337A8031904EA0A3542B339C3A240133D5C9@mdeexch.EDUC.MDE>
 <21129971.post@talk.nabble.com> <349478.64062.qm@web36601.mail.mud.yahoo.com>
 <21130846.post@talk.nabble.com>


Also, there may or may not be data in the excel sheet at all. I just format
the columns (by excel) and then put data in there accordingly (using hssf or
whatever classes). But I need to know the formatting of the columns in order
to put data in the excel sheet.


noobguru wrote:
> 
> 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--tp21099031p21130946.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