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: <[EMAIL PROTECTED]> To: <[EMAIL 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/[EMAIL PROTECTED]/msg01529.html > > Sanjeev Parwatikar > > > --------------------------------------------------------------------- > 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]
