I'd love to try Scott's stuff and have brought some of his source in, but we don't have the Java Tool Kit pieces we need installed. That's the way to create "true" Excel workbooks/spreadsheets.
You can always create an HTML table and write it out to the IFS with an .XLS extension. Seems to work fine for me. I'm sure others can point out the pro's and con's of that. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Paris Sent: Thursday, December 15, 2005 9:12 AM To: [email protected] Subject: Re: [Easy400Group] options for creating Excel spreasheets from AS/400 > Take a look at Tommy Holden's project: > > DB2/400 to Excel via POI HSSF > http://sourceforge.net/projects/iseriestoexcel I think some of Tommy's work was based on the stuff that Scott Klement and others did earlier. If you want to understand the basics of the HSSF Java classes and how to use them from RPG to create/read/update Excel spreadsheets then I suggest as well as Tommy's stuff you check out www.iSeriesNetwork.com and search for "Excel with RPG" to find the series of articles. Jon Paris ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/wbFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ###################################################################### NOTICE: The contents of this e-mail and any attachments to it may contain privileged and confidential information from Jones Apparel Group, Inc. or its affiliates. This information is only for the viewing or use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of, or the taking of any action in reliance upon, the information contained in this e-mail, or any of the attachments to this e-mail, is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this message and delete it from your system. ###################################################################### ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/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/
