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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
