Using CSV, as suggested by others, is possible, but has many pitfalls.
I used another format called SLK or SYLK successfully in some projects,
which is much better
with respect to ExCel column types and allows for some limited layout
features.
Look here:
https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)
unfortunately:
<citation>
Microsoft does not publish a SYLK specification.
Variants of the format are supported by Multiplan
<https://en.wikipedia.org/wiki/Multiplan>, Microsoft Excel
<https://en.wikipedia.org/wiki/Microsoft_Excel>, Microsoft Works
<https://en.wikipedia.org/wiki/Microsoft_Works>, OpenOffice.org
<https://en.wikipedia.org/wiki/OpenOffice.org>, and Gnumeric
<https://en.wikipedia.org/wiki/Gnumeric>.
</citation>
Anyway, (some of) my customers accepted solutions based on SYLK,
because ExCel handles the generated SLK files very well (better than CSV
files)
Kind regards
Bernd
Am 03.09.2019 um 08:13 schrieb Peter:
Hi Group
I have been using txt2pdf for a long and I understand it also does building
CSV files which can be opened using Excel. Is there a way to convert a text
file into Excel automatically within mainframe as
.XLS prior sending to email server ?
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
