PC Review


Reply
Thread Tools Rate Thread

csv to excel

 
 
=?Utf-8?B?Uml0ZXNoIEt1bWFy?=
Guest
Posts: n/a
 
      22nd Aug 2007
There is a csv file, which contains data like-
Policy,Claim,ProductCode
AA123,BB234,AL

I view this csv file in Excel. Everything is fine, except heading
Policy,Claim,ProductCode. I want to get heading in Bold.

Please help.


 
Reply With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      22nd Aug 2007
A CSV file by definition doesn't contain formatting.

You can either apply the formatting manually, or perhaps record a macro
that bolds your headings.


In article <DB2612F0-88C2-4243-BD00-(E-Mail Removed)>,
Ritesh Kumar <(E-Mail Removed)> wrote:

> There is a csv file, which contains data like-
> Policy,Claim,ProductCode
> AA123,BB234,AL
>
> I view this csv file in Excel. Everything is fine, except heading
> Policy,Claim,ProductCode. I want to get heading in Bold.
>
> Please help.

 
Reply With Quote
 
=?Utf-8?B?Y2hhbGxhIHByYWJodQ==?=
Guest
Posts: n/a
 
      28th Aug 2007
Hi,

CSV file is a Comma Seperated Values. They are just delimited by comma as
seperator. They don't store any formatting, because they are usually used for
imporing in to database and so on.

You can manually change the Formatting to these headers as bold and then
save the the file as Excel file format.

Challa Prabhu

"Ritesh Kumar" wrote:

> There is a csv file, which contains data like-
> Policy,Claim,ProductCode
> AA123,BB234,AL
>
> I view this csv file in Excel. Everything is fine, except heading
> Policy,Claim,ProductCode. I want to get heading in Bold.
>
> Please help.
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Paste failed in excel file migrated from Excel 2003 to Excel Handong Chen Microsoft Excel Crashes 1 4th Mar 2010 06:05 PM
Application coded in excel 2000 when used in excel 2003 excel doesnot perform well and takes double the time to give the output Prince Microsoft Excel Programming 4 17th Feb 2009 03:05 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= Microsoft Excel Programming 0 5th Oct 2007 10:26 AM
Excel 2003 crashes loading excel files created Excel 2000 =?Utf-8?B?SmVmZiBMZXdpbiAgQXVzdHJhbGlh?= Microsoft Excel Misc 0 27th Jun 2005 04:20 AM
Why my Excel 2003 don't open excel files by duble click on excel . =?Utf-8?B?VmFseQ==?= Microsoft Excel Crashes 1 20th Jan 2005 03:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:10 AM.