Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add color in CSV cells

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add color in CSV cells
# 1  
Old 07-21-2010
Add color in CSV cells
hi,

i have text file that file contains below information.

Name,Roll,Mark,Total
Sivasankar,2120,89,410
Raja,2212,87,425

i need to convert text file to CSV file also the heading(Name,Roll,Mark,Total) font should be BOLD and color should be RED. how can i set fonts in csv
# 2  
Old 07-21-2010
That "text" file is already a CSV (Comma Separated Values), and CSV, as a text-only format, does not support any formatting instructions.
# 3  
Old 07-21-2010
Hammer & Screwdriver CSV is a plain file
By its design, a CSV file is plain text only - no special formatting.
If you desire that, perhaps you need to convert to a spreadsheet file.

For more, take a look at definition of CSV -->
Comma-separated values - Wikipedia, the free encyclopedia
# 4  
Old 07-21-2010
how can i convert CSV to spreedsheet(XLS) with formating.
# 5  
Old 07-21-2010
Hammer & Screwdriver Search this forum, and you will find discussion on "how-to"
For instance,
https://www.unix.com/unix-linux-appli...scripting.html
# 6  
Old 07-21-2010
Quote:
Originally Posted by rsivasan
how can i convert CSV to spreedsheet(XLS) with formating.
IMHO, in this case, the easiest way is to read the file in Excel, change the color codes of the row manually and save it in excel format.
Login or Register to Ask a Question

Previous Thread | Next Thread

4 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to add 'color' in a grep?

Hello friends - I use various grep commands to search for data in a file. However, to add 'color' seems to not work. Is there a way to add color to two items that i search? so that i can easily identify in hundreds of lines of output what i am looking for? zegrep abcdefg... (7 Replies)
Discussion started by: DallasT
7 Replies

2. UNIX for Dummies Questions & Answers

Writing multiple outputs in to separate cells of CSV file

Hi I am writing a script which has multiple awk statements and each statement gives me a numeric count as an output. I want those output to be stored in different cells of a csv file. say 12 awk statements give 12 output and i want them in diffrenet cells of csv file. Thank you guys..!! (4 Replies)
Discussion started by: prabhat.diwaker
4 Replies

3. Shell Programming and Scripting

Add Color To html Doc

I have a script which converts a .csv file to html nicely. Trying to add 3 colors, green, yellow and red to the output depending upon the values in the cells. Tried some printf command but just can't seem to get any where. Any ideas would be appreciated. nawk 'BEGIN{ FS="," print ... (7 Replies)
Discussion started by: jimmyf
7 Replies

4. UNIX for Dummies Questions & Answers

How to add '--color' with pipes?

Hi guys - I was wondering if there is a way to add 'color' to a grep I do like this below: fgrep -i "XYZ-1124354-P" mylog.log | tr "\001" " " | sed G (7 Replies)
Discussion started by: DallasT
7 Replies
Login or Register to Ask a Question