RE: Need help to format CSV in Excel

[michael@xxxxxxxxxxxxxxxxxx]

If you know Java, the jxl API can create an Excel spreadsheet directly,
and then you would have control over all those things.

> -------- Original Message --------
> Subject: Need help to format CSV in Excel
> From: "murali dhar" <hydchap1@xxxxxxxxx>
> Date: Wed, February 23, 2005 12:42 pm
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> Hi, 
> 
> We have the following requirement in our project: 
> 
> 1. A csv file containing text and currency fields will be generated in user 
> specified folder 
> 2. The users want to open it in excel, so that they can slice and dice the 
> amount fields. 
> 
> 3. Is it possible to create a template so that when the users open the csv 
> file in excel the following formating is available:
> 
> A) Report title at the top 
> B) Column header row is in bold 
> C) is it possible to adjust the column widths 
> D) Format the currency amounts so that $amounts is displayed 
> 
> Please send me a mail if you can help me out with the above
> Please inform me if there is a short tutorial / reading material which can be 
> used to generate the above formatting.
> 
> appreciate your help...
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.