I have used java and jexcelapi library for that:
http://jexcelapi.sourceforge.net/
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
