Hi Marty, Take a look at Tommy Holden's project:
DB2/400 to Excel via POI HSSF http://sourceforge.net/projects/iseriestoexcel Best regards, Leif ----- Original Message ----- From: "itpweb1" <[EMAIL PROTECTED]> To: <[email protected]> Sent: 15. december 2005 14:44 Subject: [Easy400Group] options for creating Excel spreasheets from AS/400 > What are my options for creating Excel spreasheets from AS/400 > programs. AS/400 PF and spool file donwload is great, but > users are starting to want more than basic CSV import functionality. > > CSV format is good but lacks support for column width, formatting, > multi-tabed documents. > > Some power users have successfully built large complicated 'import and > format' VBA spreadsheets, but these tend to require constant > maintenance, do not scale well, are dificult to audit and usually end > up at IT's doorstep in a panic at year-end months after their creator > has left. > > We are trying to replace these VBA creations with a more centalized, > streamlined approach, but come up short in formatting and layout options. > > Ultimately I would like to generate Excel .xls files as easily as I > can now create .html files with CGIDEV2, hopefully without adding new > dedicated servers or complicated client-side software. > > I see the open source java world is getting there with new tools like > POIFS (Poor Obfuscation Implementation File System) > HSSF (Horrible Spreadsheet Format) > ref: http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi_p.html > > What are my options in the as/400 world? > > marty > > > > > > > > Yahoo! Groups Links > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/wbFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Easy400Group/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
