Robert, I like the idea of OpenOffice also ring able to create Excel spreadsheets, it ales a lot of sense to me.
Scott ford www.identityforge.com On Sep 14, 2012, at 11:41 AM, "Crawford, Robert C." <[email protected]> wrote: > I've used POI to create simple, straightforward spreadsheets and it works > fine. The program is easy enough although I'm not sure what complications > have been introduced with Excel 2007. > > Robert Crawford > CICS Technical Support > United Services Automobile Association > (210) 913-3822 > For Service Requests please use our Customer Portal. > "Seek not to follow in the footsteps of the wise; seek what they sought." - > Matsuo Basho, poet (1644-1694) > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of McKown, John > Sent: Friday, September 14, 2012 8:51 AM > To: [email protected] > Subject: Re: Creating .xls on z/OS > > Supposedly, but I haven't actually tried. Look at: > http://poi.apache.org/ > <quote> > The Apache POI Project's mission is to create and maintain Java APIs for > manipulating various file formats based upon the Office Open XML standards > (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, you > can read and write MS Excel files using Java. In addition, you can read and > write MS Word and MS PowerPoint files using Java. Apache POI is your Java > Excel solution (for Excel 97-2008). We have a complete API for porting other > OOXML and OLE2 formats and welcome others to participate. > > OLE2 files include most Microsoft Office files such as XLS, DOC, and PPT as > well as MFC serialization API based file formats. The project provides APIs > for the OLE2 Filesystem (POIFS) and OLE2 Document Properties (HPSF). > > Office OpenXML Format is the new standards based XML file format found in > Microsoft Office 2007 and 2008. This includes XLSX, DOCX and PPTX. The > project provides a low level API to support the Open Packaging Conventions > using openxml4j. > > For each MS Office application there exists a component module that attempts > to provide a common high level Java api to both OLE2 and OOXML document > formats. This is most developed for Excel workbooks (SS=HSSF+XSSF). Work is > progressing for Word documents (HWPF+XWPF) and PowerPoint presentations > (HSLF+XSLF). > > The project has recently added support for Outlook (HSMF). Microsoft opened > the specifications to this format in October 2007. We would welcome > contributions. > > There are also projects for Visio (HDGF), TNEF (HMEF), and Publisher (HPBF). > > As a general policy we collaborate as much as possible with other projects to > provide this functionality. Examples include: Cocoon for which there are > serializers for HSSF; Open Office.org with whom we collaborate in documenting > the XLS format; and Tika / Lucene, for which we provide format interpretors. > When practical, we donate components directly to those projects for > POI-enabling them. > > </quote> > > -- > John McKown > Systems Engineer IV > IT > > Administrative Services Group > > HealthMarkets(r) > > 9151 Boulevard 26 * N. Richland Hills * TX 76010 > (817) 255-3225 phone * > [email protected] * www.HealthMarkets.com > > Confidentiality Notice: This e-mail message may contain confidential or > proprietary information. If you are not the intended recipient, please > contact the sender by reply e-mail and destroy all copies of the original > message. HealthMarkets(r) is the brand name for products underwritten and > issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake > Life Insurance Company(r), Mid-West National Life Insurance Company of > TennesseeSM and The MEGA Life and Health Insurance Company.SM > > >> -----Original Message----- >> From: IBM Mainframe Discussion List [mailto:[email protected]] >> On Behalf Of Walter Marguccio >> Sent: Friday, September 14, 2012 8:44 AM >> To: [email protected] >> Subject: Creating .xls on z/OS >> >> Hello all, >> >> I've been asked if there is the possibility to create Excel tables >> (.xls) files on z/OS, >> using a batch job. I've searched the archives, the developerwork IBM's >> site, redbooks, but found no clue. >> We run the XMITIP tool which is able to create .csv files, but this >> seems not enough. >> >> We are at z/OS 1.13, with Java 6.0.1, and Perl from the Ported Tools, >> 1.2.0. >> >> Any thoughts, experiences links, books ? >> >> >> Walter Marguccio >> z/OS Systems Programmer >> BELENUS LOB Informatic GmbH >> Munich - Germany >> >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, send >> email to [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send email to > [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
