On Jun 19, 2007, at 12:23 PM, Richard Cote wrote:
I am using HSSF to generate an 600kb xls file with 4 columns and 3500
rows. All cells contain short string values. The file usually
generates without problem and can be opened in MS Excel.
...
So basically, as I'm building the string to put in the cell, I'm also
keeping note of which locations need to be highlighted.
The problem comes with this last bit of code, when I call
hssfTextString.applyFont(). I tried a small test set of data (5 rows,
each cell having two or three data items to be processed). It worked
perfectly. I then tried it with a production test set (3500 rows, each
cell having 4-5 data items). That's when I found that MS Excel could
no longer open the document
Can you partition the production test set to find out if it is a
specific row causing the problem ( either by controlling the source of
data or by counting rows in your code )? A particularly simple test
might be to use only the first 5 rows from the production test set.
Henry Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
