Wouldn't just transforming the mainframe data to CSV format and downloading work?
Chris Hoelscher Lead Sys DBA IBM Global Technical Services on assignmemt to Humana Inc. T 502.476.2538 or 502.407.7266 -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Denis Sent: Wednesday, March 24, 2021 1:10 AM To: [email protected] Subject: Re: [IBM-MAIN] Creating XLS file [External Email: Use caution with links and attachments] I have used java and jexcelapi library for that: https://urldefense.com/v3/__http://jexcelapi.sourceforge.net/__;!!IfVdvpvC!DLvzHH3VPSzKvNiOVBsflRUTebvEsqgn-VeZskMZn_Qs50j8bjivffaQ-Q5YvUZy$ Its not maintained anymore but works pretty well. I have used it to extract SMF data and data from z/OS logs.But you need to do the programming, its just an API to create a workbook and add data to it and change parameters like cell data type, size, font. Formulas can also be added to the sheets.I used the jzos record builder to create Java record classes from Assembler dsecs, but the logic needs to be programmed, like the read loop and calculating offsets. And the rdw is needed to have the record lengths. On Wednesday, March 24, 2021, 05:31:30 AM GMT+1, Peter <[email protected]> wrote: Hello I am looking for a freeware or any sample program which can covert my mainframe file into an excel file. Just to be clear we don't have SAS or any seperate tool to achieve this. Is there any working solution who can point me in the right direction? Peter ---------------------------------------------------------------------- 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 The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and do not discriminate on the basis of race, color, national origin, ancestry, age, disability, sex, marital status, gender, sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not exclude people or treat them differently because of race, color, national origin, ancestry, age, disability, sex, marital status, gender, sexual orientation, gender identity, or religion. English: ATTENTION: If you do not speak English, language assistance services, free of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711). Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711). 繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助 服務。請致電 1‐877‐320‐1235 (TTY: 711)。 Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711). Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711). 한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로 이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
