make color cell in csv file for Excel

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 t开发者_开发百科hat are preferably ascii-based, and easy to generate ?

b) Can I add column widths definitions to csv columns ?

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.