Karl has one good way to do it.

I'd like to slug whoever it is that put it into people's heads that CSV is
the universal pipe into Excel.  CSV is for raw data only, it has nothing to
do with formatting.  If you want formatting then you must understand how to
use the functionality built into Excel, and how to invoke those functions.
wIntegrate and AccuTerm are great tools but they are inadequate for this
purpose.

I spent months writing software to address the very pain that people mention
in forums almost every day, but people insist on trying to put the square
CSV peg into the round Excel hole.  I'm not making a sales pitch, just
encouraging you to take a look at this audio/video presentation to see
what's possible:
http://Nebula-RnD.com/demos/nebulanalysis/

Good luck.
Tony

>-----Original Message-----
>From: [EMAIL PROTECTED] 
>[mailto:[EMAIL PROTECTED] On Behalf Of Karl L Pearson
>Sent: Wednesday, February 04, 2004 2:31 PM
>To: U2 Users Discussion List
>Subject: Re: Format Text in Output Data File
>
>
>Open your spreadsheet program and then do a few cells with the 
>attributes you want, save them as HTML/XML and then open the 
>document with a text editor and see what the formatting codes 
>are for those cells.
>
>Karl
>
>On Wed, 2004-02-04 at 15:28, Simon Adams wrote:
>> I am trying to format text outputted to a csv data file.
>> I'm building a string of data and writing it out to a data file with 
>> 'comma' separation, line by line, and naming the outputted 
>file with a 
>> ".csv" extension.
>>  
>> Is there a way to format the text/data line(s), as "bold" or 
>"italics" 
>> or "colour" etc. without using a third-party software ?
>> 
>> Cheers, Simon.
>> 
>> Australia.
>> 
>> 
>> 
>> 
>> 
>**********************************************************************
>> ***************
>> This e-mail, including any attachments to it, may contain 
>confidential
>> and/or personal information.
>> If you have received this e-mail in error, you must not copy,
>> distribute, or disclose it, use or take any action 
>> based on the information contained within it.
>> 
>> Please notify the sender immediately by return e-mail of the 
>error and 
>> then delete the original e-mail.
>> 
>> The information contained within this e-mail may be solely 
>the opinion 
>> of the sender and may not necessarily reflect the position, 
>beliefs or 
>> opinions of Salmat on any issue.
>> 
>> This email has been swept for the presence of computer viruses known 
>> to Salmat's anti-virus systems.
>> 
>> For more information, visit our website at www.salmat.com.au.
>> 
>**********************************************************************
>> ***************
>> 
>> 
>> 
>______________________________________________________________________
>> --
>> u2-users mailing list
>> [EMAIL PROTECTED]
>> http://www.oliver.com/mailman/listinfo/u2-users
>-- 
>Karl L. Pearson
>Director of IT,
>ATS Industrial Supply
>Direct: 801-978-4429
>Toll-free: 888-972-3182 x29
>Fax: 801-972-3888
>http://www.atsindustrial.com
>[EMAIL PROTECTED]
>
>
>-- 
>u2-users mailing list
>[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
>
>

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to