Page 1 of 1

How to send an Excel format to user via IKJEFT1B

PostPosted: Wed Apr 21, 2010 4:57 am
by w91803
I used to email a CSV file only. Is there any way that I can email an Excel file to user? If you know, please let me know how. Thank you for help.

Here is my JCL for an example:


//STEP100 EXEC PGM=IKJEFT1B
//SYSEXEC DD DSN=SYS1.USER.REXX,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%XMITIP XXXXXXX@yyyy.com -
FROM XXXXXXXXX@yyyy.com -
FILE 'doc.CSV' -

Re: How to send an Excel format to user via IKJEFT1B

PostPosted: Wed Apr 21, 2010 5:43 am
by Robert Sample
If the CSV file is not good enough, as I see it you have two choices:

1. Do a market survey of data conversion vendors, find the ones that offer Excel conversion as part of their services (you may find one or more if you are lucky). If you are real, real lucky your site can purchase the product for under 100,000 U.S. dollars (depending upon the machine size, of course). Then get the training on the product and use it. I have never had this need so I've never done a market survey for data conversion products.

2. Create your own mainframe version of the Excel file format and transfer it to the PC. There is a 250-page document from Open Office on Excel file formats through Excel 2003, or you can go with the Microsoft 349-page document that includes Excel 2007. In either case, you will probably spend the better part of a year or two in doing the file formatting and testing.

CSV is simple, easy to transfer, and widely accepted. You would be better off not attempting to do a very difficult (or expensive) replacement that would not gain you much, if anything.

Re: How to send an Excel format to user via IKJEFT1B

PostPosted: Wed Apr 21, 2010 6:54 am
by dick scherrer
Hello and welcome to the forum,

Is there any way that I can email an Excel file to user?
Where is the "Excel" file created originally? Does it already exist somewhere? Are you running some mainframe product that allows creating the output in Excel format?

If you have an already formatted file, sending it should not be difficult. If creation on the mainframe is not already in place, suggest you continue using the .csv file.

Why is the .csv format no longer desired? It will open directly in Excel. . . :?