make color cell in csv file for Excel
csv, excel
Solution
No and No! CSV files are basically raw cell data, with no formatting at all.
- Office Open XML — for Excel 2007 and above
- Excel 2003 XML — for Excel 2003 and above
- HTML — not really a good option, Excel is a bit ornery in its interpretation of HTML
- Sylk (.slk)
- Open Document Format (.ods) — can be read by Excel 2010.
Problem
I am generating csv file for importing into Excel. Excel has no previous formatting. a) Is there any markup to add color definition to a cell in csv ? If not possible in csv, then in which Excel-import format(s) can I do (a) and (b), formats that are preferably ascii-based, and easy to generate ? b) Can I add column widths definitions to csv columns ?