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
