Exactly, with a distributed macro (for instance) you can pull in the CSV file adjust the columns, center headings, change fonts, etc.
Frank M. Ramaekers Jr. ________________________________ From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard Sent: Tuesday, April 20, 2010 4:27 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Converting Text to XLS I want them to have a consistent view when it is received. I don't give a damn what they do with it afterward. Regards, Richard Schuh ________________________________ From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Frank M. Ramaekers Sent: Tuesday, April 20, 2010 12:28 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Converting Text to XLS ...and you don't want to have to "futz" with Excel macros or scripts? Frank M. Ramaekers Jr. ________________________________ From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard Sent: Tuesday, April 20, 2010 1:19 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Converting Text to XLS 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 Confidentiality Note: This e-mail, including any attachment to it, may contain material that is confidential, proprietary, privileged and/or "Protected Health Information," within the meaning of the regulations under the Health Insurance Portability & Accountability Act as amended. If it is not clear that you are the intended recipient, you are hereby notified that you have received this transmittal in error, and any review, dissemination, distribution or copying of this e-mail, including any attachment to it, is strictly prohibited. If you have received this e-mail in error, please immediately return it to the sender and delete it from your system. Thank you. _____________________________________________________ This message contains information which is privileged and confidential and is solely for the use of the intended recipient. If you are not the intended recipient, be aware that any review, disclosure, copying, distribution, or use of the contents of this message is strictly prohibited. If you have received this in error, please destroy it immediately and notify us at privacy...@ailife.com. _____________________________________________________ This message contains information which is privileged and confidential and is solely for the use of the intended recipient. If you are not the intended recipient, be aware that any review, disclosure, copying, distribution, or use of the contents of this message is strictly prohibited. If you have received this in error, please destroy it immediately and notify us at privacy...@ailife.com.
