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
