It probably doesn't help much, cuz the real URL is http://jakarta.apache.org/poi/faq.html#faq-N100C2
And the short answer is that you have to limit the number of HSSFStyle objects that you create. If you create a new one for each cell, you make too many for Excel to handle. The FAQ contains good sample code. -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 11:32 AM To: POI Users List Subject: Re: creating second hssf sheet Does this help? http://jakarta.apache.org/poi/faq#faq-N100C2 On Tue, 2003-07-08 at 18:46, Singh, Arshi (Indsys) wrote: > Hi, > I have created a new workbook using POI hssf and made one excel sheet > containing a number of fonts, styles etc. After that when i try to create a > second sheet , it gives problems. > If i try to create a small sheet 2 with a few lines of different > fonts then the fonts do not show as desired in sheet 2 and if i try to > create a big sheet 2 having tables and orientations then the my output excel > file does not even open up and shows the error "Too Many Different Cell > Formats". > Can somebody please help me detect the error. Could it be because of > some buffer in memory ???? > Thanks, > Arshi. > [useless trailers snipped] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
