You guys are great! We have been puzzeling over this for 2 weeks, and within 2 hours, I have a half dozen better answers than we could come up with!
Scott and Tommy's stuff looks great. Hopefully one day stuff like this could be standard service programs included with the RPG license, or maybe (don't pummel me Scott) included in CGIDEV2. However I kick myself for not trying to simply add the .xls extention when I create an HTML file. This was the type of solution I was looking for! After a few tests I found that using tables, controlling cell width and tweaking the html a bit, Excel does a pretty good job at interpretting the html code. You have to give credit to Microsoft for putting so many 'extras' in their application. Careful on big files, however because Excel seems to take much longer to interpret and import html than csv. I cross posted this question to comp.sys.ibm.as400.misc because I bet there are dozens of other organizations struggling with these questions today. marty --- In [email protected], "DirkHauwaerts" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/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/
