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 > > > >