Add color in CSV cells

Shell Programming and Scripting
1

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

That "text" file is already a CSV (Comma Separated Values), and CSV, as a text-only format, does not support any formatting instructions.

3

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

how can i convert CSV to spreedsheet(XLS) with formating.

5

For instance,

6

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.