poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dirk.Rost@appshare.de" <Dirk.R...@appshare.de>
Subject Re: strange behaviour using row and column styles
Date Wed, 22 Dec 2004 08:58:54 GMT
HSSFCellStyle cellStyle = cell.getCellStyle();

best regards

                    _____ __
  ____ _____  ____ / ___// /_  ____ _________
 / __ `/ __ \/ __ \\__ \/ __ \/ __ `/ ___/ _ \
/ /_/ / /_/ / /_/ /__/ / / / / /_/ / /  /  __/
\__,_/ .___/ .___/____/_/ /_/\__,_/_/   \___/
    /_/   /_/             all byte - no bark
    ---------------------------------------------




Thibaut Nicolas wrote:

> Hi,
>
> Has somebody ever met this problem ? Can someone tell me how can I get 
> existing row and column styles ? I didn't find it in HSSF api :-(
>
> thanks in advance,
>
> thibaut
>
>
>
> Thibaut Nicolas a écrit :
>
>> Hi all,
>>
>> I'm having trouble using POI to modify an existing XLS file.
>> I create an XLS file as follow :
>>   - column C is formatted to use bold font
>>   - row 2 is formatted to have a yellow background color.
>> Then I use POI to insert values in this template.
>>
>> When reading the sheet, I can only retrieve the cell C2 and I can 
>> easily insert the value inside without loosing the cell formatting.
>> But I can't find any other cell. Anyway I can create the other cells 
>> I want to put data inside.
>> Then I don't know where to find the stored style properties so that 
>> all cells added in column C are in bold and all cells added in row 2 
>> are yellow.
>>
>> Thanks in advance for any help
>>
>> Thibaut
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message