Re: Text to excel

2019-09-04 Thread Timothy Sipples
Yes, Apache POI (the Java API for Microsoft Documents) should be able to create Microsoft Excel (.xls) format files on z/OS. It's a set of Java APIs, of programming libraries. You would install and use it just as you would any other Java APIs on z/OS. xlsx4j (docx4j) is another possibility if

Re: Text to excel

2019-09-03 Thread Peter
I was going through the old thread .. seems https://poi.apache.org/ Does the conversion if we have our own custom java .. well has anyone used it and how do we make it work? On Tue, 3 Sep, 2019, 9:39 PM Paul Gilmartin, < 000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > On Tue, 3 Sep

Re: Text to excel

2019-09-03 Thread Paul Gilmartin
On Tue, 3 Sep 2019 10:12:54 -0700, Tom Brennan wrote: >And be careful even with the quotes. For example, if I use a script to >create a csv file containing something like this: > >"3390","12E3" > >On my Win 10 system, even with the quotes that unit address turns into a >number because Excel

Re: Text to excel

2019-09-03 Thread Tom Brennan
around the number fields. On Tue, Sep 3, 2019 at 1:13 AM Peter wrote: 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 fil

Re: Text to excel

2019-09-03 Thread Bernd Oppolzer
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 se

Re: Text to excel

2019-09-03 Thread Paul Gilmartin
nvert SMP/E Enhanced Holddata to .CSV. Still works. But, always, utterly dependent on input data format. It might provide an example. >On Tue, Sep 3, 2019 at 1:13 AM Peter wrote: >> >> I have been using txt2pdf for a long and I understand it also does building >> CSV files

Re: Text to excel

2019-09-03 Thread Lionel B Dyck
haracter is what you are, reputation merely what others think you are." - John Wooden -Original Message- From: IBM Mainframe Discussion List On Behalf Of Peter Sent: Tuesday, September 3, 2019 1:13 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Text to excel Hi Group I have been

Re: Text to excel

2019-09-03 Thread Sean Gleann
three" > Probably would be better to even put quotes around the number fields. > > On Tue, Sep 3, 2019 at 1:13 AM Peter wrote: > > > > Hi Group > > > > I have been using txt2pdf for a long and I understand it also does > building > > CSV files which

Re: Text to excel

2019-09-03 Thread Mike Schwab
, 2019 at 1:13 AM Peter wrote: > > 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

Text to excel

2019-09-03 Thread 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