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 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/
