Thanks Anthony.But iam using different styles for different objects.For
example for date iam using
HSSFCellStyle csDate = wb.createCellStyle();
HSSFCellStyle csDouble = wb.createCellStyle();
I have different styles for different datatypes such as double etc..
So based on the row count i can set the color,but if iam using following
code.
Iam looping through row and for each cell iam checking the datatype.
if(value instanceof Double)
{
if(!(rownum%2==0))
{
csDouble.setFillForegroundColor(HSSFColor.AQUA.index);
csDouble.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
}
}
So iam using many styles in a row,i mean for different cells i have
different styles.So if iam using above code and setting color.That color is
being applied through out the sheet.
So any solution please??
Anthony Andrews wrote:
>
> As far as I know, there is no way to set the style for a row; so, you are
> going to have to set the style for each cell as you create it.
>
> If it were me. I would create the style objects for each 'row' firstly,
> outside of any loop. So;
>
> HSSFCellStyle evenRowCellStyle = wb.createCellStyle();
> evenRowCellStyle.setBackgroundFillColor(HSSFColor.AQUA.index);
> HSSFCellStyle oddRowCellStyle = wb.createCellStyle();
> oddRowCellStyle.setBackgroundFillColor(HSSFColor.RED.index);
>
> Where wb is the reference to a workbook I have created.
>
> Now, I do not know how you are creating your cells, but the example I will
> give is of a couple of loops; the outer loop creates rows, the inner
> cells. So;
>
> HSSFSheet sheet = wb.createSheet("Colouring Test");
> HSSFRow row = null;
> HSSFCell cell = null;
>
> for (int rowNum = 0; rowNum < 10; rowNum++) {
>
> row = sheet.createRow((short)rowNum);
>
> for(int cellNum = 0; cellNum < 10; cellNum++) {
> cell = row.createCell((short)colNum);
>
> if((rowNum % 2) == 0) {
>
> cell.setCellStyle(evenRowCellStyle);
> }
> else {
>
> cell.setCellStyle(oddRowCellStyle);
> }
> }
>
> }
>
> You may even find that you only need to create a single cell style object,
> try it on a small test sheet and see.
>
> PS - Hope this works, I did not test it simple typed the code into the
> browser. If not, just let me know.
>
>
> --- On Mon, 6/9/08, suriz4u <[EMAIL PROTECTED]> wrote:
> From: suriz4u <[EMAIL PROTECTED]>
> Subject: Re: Needs clarity about Cell Styles
> To: [email protected]
> Date: Monday, June 9, 2008, 2:40 AM
>
> Thanks for such a good explanation.But in my application there is
> requirement that alternative rows should be colored.As iam using different
> styles for different objects.I tried to use in following way for different
> objects
>
> HSSFCellStyle csDouble= wb.createCellStyle();
> if(!(rowNumber%2==0))
> csDouble.setFillBackgroundColor(HSSFColor.AQUA.index);
>
> But it didnt worked in this way..
> Is there any solution for this???
>
>
>
>
>
> Anthony Andrews wrote:
> >
> > Yes, you need to create a different style object for each cell style
> that
> > your sheet requires. Typically, people tend to accomplish this task
> at the
> > start of the application - assuming of course they know at that stage
> all
> > of the cell styles they require. This is not to say, of course, that
> there
> > is anything wrong with creating styles as you go, just try to avoid
> > duplicates if memory could be an issue for you.
> >
> > If you do try to reuse cell styles by modifying the style object once
> it
> > has been created, you will (should) find that all of your cells will
> have
> > the same appearance. This occurs because the cell style objects are
> > interpreted (interrogated) when you call the write method if I
> understand
> > correctly.
> >
> > --- On Sun, 6/8/08, suriz4u &lt;[EMAIL PROTECTED]&gt; wrote:
> > From: suriz4u &lt;[EMAIL PROTECTED]&gt;
> > Subject: Needs clarity about Cell Styles
> > To: [email protected]
> > Date: Sunday, June 8, 2008, 10:49 PM
> >
> > Hi all
> > Iam using cellstyles in POI to generate excel.For formatting
> > different datatypes iam using different styles.
> >
> > For example for formatting date iam using
> > HSSFCellStyle csDate = wb.createCellStyle();
> > Iam creating different cellstyles for different datatypes.I tried to
> use
> > only one cellStyle but it doesnt worked.
> >
> > Is it recommendable to create different cell styles for different
> > datatypes???
> >
> > Please any one can give me solution for this...
> >
> > Thanks
> > Suresh G
> > --
> > View this message in context:
> >
> http://www.nabble.com/Needs-clarity-about-Cell-Styles-tp17726681p17726681.html
> > Sent from the POI - User mailing list archive at Nabble.com.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Needs-clarity-about-Cell-Styles-tp17726681p17729434.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
--
View this message in context:
http://www.nabble.com/Needs-clarity-about-Cell-Styles-tp17726681p17747584.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
