08-22-2014 04:28 AM
buHow to generate a Excel output with multiple tabs on z/os ( Mainframe ) environment? Can any one suggest how to achieve this?
08-22-2014 06:23 AM
I do this by using ODS statements
ODS LISTING CLOSE;
ODS TAGSETS.EXCELXP FILE=MYXLS1 RS=NONE STYLE=SEASIDE
PROC PRINT DATA=TOT NOOBS U;
ODS TAGSETS.EXCELXP CLOSE;
ODS LISTING ;
08-22-2014 08:13 AM
In addition to what Jajeuk coded - you need to download the resulting file from the mainframe to the target system that has
Excel on it before you can view it as a spreadsheet. Since our Mainframe (the USS side) was in ASCII, we had to do a binary
download so the characters were not translated.
Also remember that the file created on the mainframe (from the EXCELXP tagset) is a XML file, not native Excel format so once it
is on the target system, you may want to run a VOB script to convert it to a native Excel file.