date: Fri, 28 Sep 2012 10:37:56 -0400
subject: Dynamic java for Excel spreadsheet
We have run into various memory and performance issues using the JNI
interface from RPG to Java to generate spreadsheets using the POI HSSF
API's. Sometimes to get around this, we generate the spreadsheet in a .CSV
format, but this obviously generates a pretty ugly output when imported
into Excel. I'm currently researching generating the java code dynamically
in an RPG program, compiling it, and running that, meaning that the there
would be at least one java code source record for every cell on the
spreadsheet. I believe that the resulting program would perform much
better than the JNI interface does. Does anyone see any show stoppers with
this approach? Anyone tried something like this before?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.