You would have to ask the ISO folks. That is what they specified. I suspect they want to play with it using secret macros.
Regards, Richard Schuh > -----Original Message----- > From: The IBM z/VM Operating System > [mailto:ib...@listserv.uark.edu] On Behalf Of Ron Schmiedge > Sent: Tuesday, April 20, 2010 11:27 AM > To: IBMVM@LISTSERV.UARK.EDU > Subject: Re: Converting Text to XLS > > Richard, > > I've a dumb question to ask - why does the CMS file have to > be opened by a spreadsheet program? > > > > On Tue, Apr 20, 2010 at 12:19 PM, Schuh, Richard > <rsc...@visa.com> wrote: > > Right now, I am creating a csv file using tab (x'05', which is also > > the default field separator in Pipelines) characters as a > separator. > > Since I do not have control of the width of cells, I need > to be able > > to selectively specify whether to align right or left and top or > > bottom in the cells of a column. I suppose I could use a > multiple pass > > process where I get the max size of a cell in each column > and create > > fixed size cells and align things myself. Then, there are > such things > > as table and column headings and anything else needed to > make it print > > friendly. Even then, the output would still be a text > file. not xls. > > > > The short of it is, I am trying to make it so that the > recipient does > > not have to futz with formats or headings when the file is > opened by > > Excel. I have seen some really strange formats when looking > at files > > that people (in ISO, but I will give them the benefit of > the doubt) have messed up. > > > > Regards, > > Richard Schuh > > > > > > > > > > > > ________________________________ > > From: The IBM z/VM Operating System > [mailto:ib...@listserv.uark.edu] > > On Behalf Of Wandschneider, Scott > > Sent: Tuesday, April 20, 2010 10:40 AM > > To: IBMVM@LISTSERV.UARK.EDU > > Subject: Re: Converting Text to XLS > > > > I create several text files on CMS where I use the > or < > character as > > a delimiter and surround special text with ". > > > > > > > > Thank you, > > > > > > > > Scott > > > > > > > > From: The IBM z/VM Operating System > [mailto:ib...@listserv.uark.edu] > > On Behalf Of Schuh, Richard > > Sent: Tuesday, April 20, 2010 12:27 PM > > > > To: IBMVM@LISTSERV.UARK.EDU > > Subject: Converting Text to XLS > > > > > > > > Does anyone know of a program to create an XLS file from a > text file on CMS? > > The file can be sent as a CSV file attached to an e-mail; however, > > opening the CSV file with Excel or other spreadsheet > programs exposes > > a few formatting problems/inconsistencies that must be > fixed by manual > > manipulation. > > > > > > > > Regards, > > Richard Schuh > > > > > > > > >