 | | | Excel: Too many different cell formats | Excel: Too many different cell formats 2004-01-22 - By avik.sengupta@(protected)
Back
Thanks for the note!
Quoting Sanjeeva_Parwatikar@(protected):
>
>
>
>
> I resolved the issue. Although cellStyles were highly reused whenever the
> styles were being set on the cells , I was creating temporary styles by
> creating new styles. Be careful not to call workbook.createCellStyle( )
> too may times whether you use it or not.
>
> Sanjeev Parwatikar
> -- -- Forwarded by Sanjeeva Parwatikar/HQ/FHLMC on 01/22/2004 12:54 PM
> -- --
>
>
> Sanjeeva
>
> Parwatikar To:
> poi-user@(protected)
>
> cc:
>
> 01/16/2004 03:38 Subject: Excel: Too many
> different cell formats
> PM
>
>
>
>
>
>
>
>
> 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.
|
|
|