Thanks David.I got your point.But i thought i would get an alternate solution
,because i have to create so many objects.Any way its working,thanks once
again
Thanks
Suresh
David Fisher wrote:
>
> You know you've asked the same question in three threads.
>
> You need to have:
>
>
> HSSFCellStyle stringStyleOdd = wb.createCellStyle();
> HSSFCellStyle intStyleOdd = wb.createCellStyle();
> HSSFCellStyle longStyleOdd = wb.createCellStyle();
> HSSFCellStyle doubleStyleOdd = wb.createCellStyle();
> HSSFCellStyle dateStyleOdd = wb.createCellStyle();
> HSSFCellStyle timeStampStyleOdd = wb.createCellStyle();
>
> AND
>
> HSSFCellStyle stringStyleEven = wb.createCellStyle();
> HSSFCellStyle intStyleEven = wb.createCellStyle();
> HSSFCellStyle longStyleEven = wb.createCellStyle();
> HSSFCellStyle doubleStyleEven = wb.createCellStyle();
> HSSFCellStyle dateStyleEven = wb.createCellStyle();
> HSSFCellStyle timeStampStyleEven = wb.createCellStyle();
>
> One of each data type for each.
>
> Also if different doubles have different numeric formats then you'll
> need a unique style for each format.
>
> Maybe doubleStyle999o99Even, doubleStyle999o9Even,
> doubleStyle999o99Odd, doubleStyle999o9Odd
>
> Completely set up all of your possible styles as a unique style before
> your loop.
>
> Then you call according to the needs of the field.
>
> Do NOT keep changing a style record for each cell as you iterate. When
> you do that you end up with the last version of the style record for
> every cell that you have assigned that style record no matter what
> state that style record was in when you called it.
>
> You are thinking that you are setting the state of the cell with that
> style, but that's NOT how it works. When you assign a style you are
> linking objects - a style object and a cell object. You can then
> change either.
>
> I hope this helps.
>
> Regards,
> Dave
>
> On Jun 10, 2008, at 12:02 AM, suriz4u wrote:
>
>>
>> Hi all
>> I have problem with coloring cells.I should have a color for every
>> alternative row.So i tried in the following way,but iam getting same
>> aqua
>> color for every row.Iam pasting my code .Can any one help me out
>> please.........
>>
>> public void makeExcel(List list,String fields[][],OutputStream out)
>> throws
>> Exception
>> {
>> HSSFWorkbook wb = new HSSFWorkbook();
>> HSSFSheet sheet = wb.createSheet();
>> HSSFRow row = null;
>> HSSFCell cell = null;
>> HSSFCellStyle columnHeaderStyle = wb.createCellStyle();
>> HSSFDataFormat dataFormat = wb.createDataFormat();
>> HSSFCellStyle stringStyle = wb.createCellStyle();
>> HSSFCellStyle intStyle = wb.createCellStyle();
>> HSSFCellStyle longStyle = wb.createCellStyle();
>> HSSFCellStyle doubleStyle = wb.createCellStyle();
>> HSSFCellStyle dateStyle = wb.createCellStyle();
>> HSSFCellStyle timeStampStyle = wb.createCellStyle();
>> HSSFFont normalFont = wb.createFont();
>> HSSFFont boldFont = wb.createFont();
>> normalFont.setFontHeightInPoints((short) 9);
>> boldFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
>>
>> columnHeaderStyle.setFont(boldFont);
>> stringStyle.setFont(normalFont);
>> intStyle.setFont(normalFont);
>> longStyle.setFont(normalFont);
>> doubleStyle.setFont(normalFont);
>> dateStyle.setFont(normalFont);
>> timeStampStyle.setFont(normalFont);
>>
>> wb.setSheetName(0, "Test1",
>> HSSFWorkbook.ENCODING_COMPRESSED_UNICODE
>> );
>> short fieldSize=0;
>> int rownum=0;
>> row = sheet.createRow(rownum++);
>> for(short j=0;j<fields.length;j++)
>> {
>> cell=row.createCell(j);
>> cell.setCellValue(fields[j][1]);
>> cell.setCellStyle(columnHeaderStyle);
>> }
>> System.out.println("Start time"+ new java.util.Date());
>>
>> IBean iBean=null ;
>> Iterator it =list.iterator();
>> while(it.hasNext())
>> {
>> row = sheet.createRow(rownum++);
>> iBean = (IBean)it.next();
>> if(rownum>=maxRowCount )
>> {
>> rownum=0;
>> sheet= wb.createSheet("Test"+(wb.getNumberOfSheets()
>> +1));
>> row = sheet.createRow(rownum++);
>> wb.getSheet("Test"+((wb.getNumberOfSheets())+1));
>> for(short j=0;j<fields.length;j++)
>> {
>> cell=row.createCell(j);
>> cell.setCellValue(fields[j][1]);
>> cell.setCellStyle(columnHeaderStyle);
>> }
>> row = sheet.createRow(rownum++);
>> }
>> for(short i=0;i<fields.length;i++)
>> {
>> try
>> {
>> Object
>> value=PropertyUtils.getNestedProperty(iBean,fields[i][0]);
>> if(value == null)
>> value=""; // initialize the null values to
>> empty.
>> cell=row.createCell(i);
>> if(value instanceof Double)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> doubleStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> doubleStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>> else
>>
>> doubleStyle.setFillForegroundColor(HSSFColor.WHITE.index);
>> if(fields[i][2]!=null && fields[i]
>> [2].length()>0)
>> {
>>
>> doubleStyle.setDataFormat(dataFormat.getFormat(fields[i][2]));
>> cell.setCellStyle(doubleStyle);
>> }
>> if(value.equals(""))
>> cell.setCellValue("");
>> else
>> cell.setCellValue(
>> ((Double)value).doubleValue() );
>> }
>> if(value instanceof Integer)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> intStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> intStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>> else
>>
>> intStyle.setFillForegroundColor(HSSFColor.WHITE.index);
>> if(fields[i][2]!=null && fields[i]
>> [2].length()>0)
>> {
>>
>> intStyle.setDataFormat(dataFormat.getFormat(fields[i][2]));
>> cell.setCellStyle(intStyle);
>> }
>> if(value.equals(""))
>> cell.setCellValue("");
>> else
>> cell.setCellValue(
>> ((Integer)value).intValue() );
>> }
>> if(value instanceof java.sql.Date)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> dateStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> dateStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>>
>> if(fields[i][2]!=null && fields[i]
>> [2].length()>0)
>> {
>>
>> dateStyle.setDataFormat(dataFormat.getFormat(fields[i][2]));
>> cell.setCellStyle(dateStyle);
>> }
>> if(value.equals(""))
>> cell.setCellValue("");
>> else
>>
>> cell.setCellValue( (java.sql.Date)value );
>> }
>> if(value instanceof java.sql.Timestamp)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> timeStampStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> timeStampStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>> else
>>
>> timeStampStyle.setFillForegroundColor(HSSFColor.WHITE.index);
>>
>> if(fields[i][2]!=null &&
>> fields[i][2].length()>0)
>> {
>>
>> timeStampStyle.setDataFormat(dataFormat.getFormat(fields[i][2]));
>> cell.setCellStyle(timeStampStyle);
>> }
>> if(value.equals(""))
>> cell.setCellValue("");
>> else
>> cell.setCellValue( new
>> java.util.Date(((java.sql.Timestamp)value).getTime()) ) ;
>> }
>> else if(value instanceof Long)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> longStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> longStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>>
>> if(fields[i][2]!=null &&
>> fields[i][2].length()>0)
>> {
>>
>> longStyle.setDataFormat(dataFormat.getFormat(fields[i][2]));
>> cell.setCellStyle(longStyle);
>> }
>>
>> cell.setCellValue( ((Long)value).longValue()
>> );
>> }
>>
>> else if(value instanceof String)
>> {
>> if(!(rownum%2==0))
>> {
>>
>> stringStyle.setFillForegroundColor(HSSFColor.AQUA.index);
>>
>> stringStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
>> }
>>
>> cell.setCellStyle(stringStyle);
>> cell.setCellValue( (value).toString() );
>> }
>> }
>> catch(Exception ex)
>> {
>> throw ex;
>> }
>> }
>> }
>> for(int i=0;i<wb.getNumberOfSheets();i++)
>> {
>> for(short j=0;j<fields.length;j++)
>> {
>> wb.getSheetAt(i).autoSizeColumn((short)j);
>>
>> }
>> }
>> wb.write(out);
>> System.out.println("End time"+ new java.util.Date());
>> }
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Problem-with-Colors-tp17747845p17747845.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]
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/Problem-with-Colors-tp17747845p17748373.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]
