Menu
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 ?
517
CSV is a pure data format without any formatting. It's a plain text file after all. So no, there is no way of adding colour.
The short answer is no. The long answer is also no. Csv is a text data format, not a display format.
Simply select the cells that you want to fill, press the Alt + H keys on your keyboard, and then press the F + I keys. This will open the "Fill" menu. From there, you can use the arrow keys to select the color that you want to use, and then press the Enter key to fill the cells.
No and No! CSV files are basically raw cell data, with no formatting at all.
150
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
