Generating an excelsheet with POI…
September 23, 2010 Leave a Comment
It’s very easy for an lotusscript developer to generate an excel sheet with some OLE… but when the code should be run on the server it’s getting bad.
My last entry was about to pass a vector to the java API from lotusscript. Here some background to create the excel sheet with POI.
Of course you should customize this code to fit your solution. If it run on the server with a lot of instances, remember to do some stress tests to avoid some servers issues.
Greetings…
First get – POI Export with poi 3.2
http://www.criverapr.com/2008/10/using-poi-to-export-lotus-notes-data-to.html
Second – ls2j and dynamic array
http://www-10.lotus.com/ldd/nd6forum.nsf/c21908baf7e06eb085256a39006eae9f/45bc5292d67167508525706500525a52?OpenDocument
About pierrekoerber
