hi Brian, create the font once (!) like this:
HSSFFont lvFont = lvWorkbook.createFont(); lvFont.setColor(...); lvFont.set... and the use this font for every cell: aHSSFCellStyle.setFont(lvFont), cheers Dirk -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 12. Dezember 2003 17:00 An: [EMAIL PROTECTED] Betreff: Default Font in Spreadsheet I have created a small program that exports data to an Excel spreadsheet using HSSF. My first try at this I set the Font on every cell that I created. I found out however that if the spreadsheet gets very big you get an error when opening the spreadsheet (in Excel). The error says that the maximum number of Fonts has been exceeded. My question is this. Is there a way in HSSF to set the "Default Font" for an entire spreadsheet? Excel calls it a "Standard Font". Any help here would be appreciated Brian Andersen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
