 | | | Excel: Too many different cell formats | Excel: Too many different cell formats 2004-07-03 - By Jeff Blackwell
Back
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: <Sanjeeva_Parwatikar@(protected)>
To: <poi-user@(protected)>
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@(protected)/msg01529.html
>
> Sanjeev Parwatikar
>
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe, e-mail: poi-user-unsubscribe@(protected)
> For additional commands, e-mail: poi-user-help@(protected)
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: poi-user-unsubscribe@(protected)
For additional commands, e-mail: poi-user-help@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|