Re: Improving Excel generation performance through calling Java

hi Darren,

We were using the HSSFR4 service program you so helpfully provided, and it
appeared to me that it attempts to signal all objects for garbage
collection when they have become obsolete

HSSFR4 will clean up the objects that it creates as long as they are only used within HSSFR4 and not passed back to your program.

_You_ are expected to clean up everything else by calling the hssf_begin_object_group/hssf_end_object_group or hssf_FreeLocalRef routines.

I strongly recommend the object group routines, as it's very easy to miss stuff with the localref routine.

hssf_freeLocalRef doesn't actually clean up as well as it should. As
someone else pointed out, we're telling the JVM to garbage collect per
IBM's spec, but it doesn't really clean everything until JVM ends.

If you do a begin_object_group at the start of your code, and end_object_group at the end, it doesn't clean up all of the objects??