If you are a DB2 pureXML (with XQuery Update) facility, I had a sample where, the unzipped .ods files are queried/modified as required by the ODF schema. The unzipped files are of course XML. http://opendocument.xml.org/resource/using-db2-purexml-and-odf-spreadsheets
On 9/15/12, Scott Ford <[email protected]> wrote: > Wow, Sam very nice .... > > Scott ford > www.identityforge.com > > On Sep 14, 2012, at 10:54 AM, Sam Siegel <[email protected]> wrote: > >> Walter - I have recently completed development of a COBOL and Assembler >> compatible API that allows the creation of full fidelity .xls and .xlsx >> spreadsheets. Below is a summary of supported functions. >> >> Full unicode support >> Ebcdic (all code pages) to unicode >> Packed, binary integers, ibm hex float >> Row oriented data insertion >> Cell oriented data insertion >> Jpeg, bmp image support >> Formulas >> Multiple tabs >> Lots more >> >> I also have a simple control card driven utility (built on the api) that >> allows a sequential file to be placed in a .xls or .xlsx format. >> >> I also have many sample COBOL and assembler programs for usage examples. >> >> There is no dependency on any third party products. No need for Java. >> The .xls and .xlsx file can be binary downloaded and opened directly by >> excel. >> >> Sam >> Sent from my Verizon Wireless BlackBerry >> >> -----Original Message----- >> From: Walter Marguccio <[email protected]> >> Sender: IBM Mainframe Discussion List <[email protected]> >> Date: Fri, 14 Sep 2012 06:44:23 >> To: <[email protected]> >> Reply-To: IBM Mainframe Discussion List <[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
