rows, one for even), and then reuse those styles?
So ... The code/pseudocode might look like ...
HSSFCellStyle HeadStyle = Workbook.createCellStyle();
HSSFCellStyle OddStyle = Workbook.createCellStyle();
HSSFCellStyle EvenStyle = Workbook.createCellStyle();
HeadStyle.setFillBackgroundColor(HSSFCellStyle.RED);
OddStyle.setFillBackgroundColor(HSSFCellStyle.GREEN);
EvenStyle.setFillBackgroundColor(HSSFCellStyle.BLUE);
...
if ( (HSSFRow.getRowNum() mod 2) == 0)
Cell.setCellStyle(EvenStyle);
else
Cell.setCellStyle(OddStyle);
...
?
Curtis
-----Original Message-----
From: Felipe Castro [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 9:06 AM
To: POI Users List
Subject: Re: Question about Cell Styles in Excell
I see, but I don't know beforehand how many rows I'll write. Also, the
"table" I'm trying to write should be "centered" on the sheet for
readability. I don't use the upper, lower, left and rightmost rows and
columns of my sheet. I don't know if templates would help...
----- Original Message -----
From: "Karl-Heinz Zengerle" <[EMAIL PROTECTED]>
To: "'POI Users List'" <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 11:49 AM
Subject: AW: Question about Cell Styles in Excell
Hi Felipe.
In Excel you can also set styles for whole rows or columns and then
override some styles of specific cells (e.g. header cells). So it should
also be possible in POI. This way the quantity of settings should be
small.
When I hear alternating styles I'ld first think about styles on higher
level.
Regards, Karl-Heinz.
-----Urspr�ngliche Nachricht-----
Von: Felipe Castro [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 11. Mai 2004 16:39
An: POI Users List
Betreff: Re: Question about Cell Styles in Excell
Thank you for all your feedback..
Yes... I'm just trying to alternate colors on data rows. The need to
create different styles for each cell almost makes impracticable the use
of
POI for decently formatted sheets. Maybe POI could think of some kind of
style hierarchy or, at least, implement the "clone" method in the
HSSFCellStyle class. If one could clone a style, he could change only
the
cell data format and wouldn't need to reset all style properties for
each
cell with a different format.
I'm not sure but I thought of that in less than 5 minutes... There
must
be a good reason for not implementing it.
As for templates, I don't know exactly how to use them. Should I
create
an empty 2 line table (in the template) and use POI to get those lines
styles and aply them to new cells?
Thanks again,
Felipe
----- Original Message -----
From: "Mehner, Bj�rn" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 4:38 AM
Subject: AW: Question about Cell Styles in Excell
Let me see if I get it straight. Please suppose I have a
simple table with 1 title row, two data rows and 6 columns.
Each of these rows has it's own fill color and each of the
data columns has it's own data format (the title row is, of
course, formed of strings). If the only way to set a fill
color and data format is by a cell style, does that mean that
I have to create 6 * 2 + 1 = 13 different cell styles to
accomplish the desired format? Is that right?
Unfortunately I think you are right. Do you really have to have
different colors each data row? Sounds strange to me. What are you
doing
if the table has more than 2 rows? Alternating colours?
ciao Bodo
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
