What languages do you have available? If you have a current Java, then I'd suggest looking at Apache:POI
http://poi.apache.org/ John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM ________________________________ 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.