Hello, In our applications we use the jakarta poi project were we can read/write excel files on our as/400. Around this we wrote an rpg-wrapper so we can read and write excel files in rpg programs.
http://jakarta.apache.org/poi/index.html --- In [email protected], "dandeejones" <[EMAIL PROTECTED]> wrote: > > I've had great success formatting data for Word, Excel by using HTML documents. You can even code =SUM(A1:A10) in your html document, when execl opens the document it does the math for you. For the finishing touch, name the document with a .xls extension and the user won't even know it is really html. > > --- In [email protected], "itpweb1" <[EMAIL PROTECTED]> wrote: > > > > 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/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/
