i'm currently evaluating a product called launcher/400 office.
will read / update / create new xls and word documents from
cl/rpg.
more impressively it'll convert them to pdf's and email on also.!
formula's / borders / shading / logo's are a doddle (all the usual
microsoft formatting supported)
-----Original Message-----
From: "itpweb1" <[EMAIL PROTECTED]>
To: [email protected]
Date: Thu, 15 Dec 2005 13:44:45 -0000
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
CONFIDENTIALITY NOTICE : This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under law. If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you received this in error, please contact the sender and delete the material from any computer.
We have taken precautions to minimise the risk of transmitting software viruses, however, you need to carry out your own virus checks on any attachments as we can take no responsibility for any computer virus transferred by way of this email.
All views or opinions expressed will be those of the author and not necessarily those of Harry Yearsley Ltd.
Business is conducted as under our Terms and Conditions available on request.
SPONSORED LINKS
| How to format a computer hard drive | Cobol programmer | Iseries 400 |
| How to format a computer |
YAHOO! GROUPS LINKS
- Visit your group "Easy400Group" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
