Re: Excel: Too many different cell formats

[Jeff Blackwell <jb...@tenacityinc.com>]

Sanjeev -

Just a suggestion, but make sure that the Styles are instantiated _outside_
the loop.  The code that you linked to built a Style for each cell.  Is
yours doing this?  Might want to instantiate Style1,Style2, etc. from your
registry, then use

cell.setCellStyle(style1);

etc. to set the CellStyle in the loop.

I believe that's what the responses below the code you linked to were
saying.

Cheers,
Jeff
----- Original Message ----- 
From: <Sa...@freddiemac.com>
To: <po...@jakarta.apache.org>
Sent: Friday, January 16, 2004 3:38 PM
Subject: Excel: Too many different cell formats


>
>
>
>
> I have excel workbook containing many sheets where each contains around
> 5000 cells.  The total number of cell styles created and used are less
than
> 25 and are  maintained in a registry (highly reused).  Even though the
cell
> styles created are very less, I cannot open the generated excel workbook
> (too many different cell formats error).
>
> Please refer to
> http://www.mail-archive.com/poi-user@jakarta.apache.org/msg01529.html
>
> Sanjeev Parwatikar
>
>
> ---------------------------------------------------------------------
> 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