RE: HSSF POI performance huge memory usage

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> What would be cool is if somebody would come up with a layered approach
> that
> would allow the RPG programmer to write cell contents to a DB2 table,
> then
> invoke a Java process to go through all the values in DB2 and apply
> them to
> a spreadsheet.  It actually wouldn't be that hard to write now that I
> think
> about it - very similar in nature to my RPG Chart Engine which you can
> check
> out if you want (free and open source:
> http://mowyourlawn.com/RPGChartEngine.html)

I took the SQL2SYLK command/source and modified it to use HSSF POI (renamed,
of course to SQL2XLS - being such a creative soul ;)).  It would be very
difficult to divorce from service programs that I have in place, but if
there's significant demand, I could share....  That sounds like it would
give e you what you requested here.


Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I am returning this otherwise good typing paper to you because someone has
printed gibberish all over it and put your name at the top.
        -- English Professor, Ohio University