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:48:09 GMT

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


Mime
View raw message