# Cell-Level Attributes

> [HTML Version](cell-levelattributes.htm)

_Added June 2020_

CSV2XL provides support for cell-level attributes using the syntax:

**"<attr=value,...,attr=value/>field data", ...**

The attribute clause must begin with "<" and end with "/>", and there needs to be quotes around the entire combination of the attribute clause and the field data. (WRITECD will take care of the quoting.) The attribute list may contain any of the Common XL Parameters, except _mask_ and _formatid_. Any attributes specified at the cell level are combined with the attributes previously defined by the SetCol directive for that column.

For example, in the following data line, all fields will output using the attributes previously set, but the middle field font will be changed to lavender and bold.

hello,"<fontcolor=COLOR\_LAVENDER,bold/>Bonjour",Hola

Also, a new shorthand attribute _bgc_ has been defined to set the background color, which otherwise requires setting the fillpattern to FILLPATTERN\_SOLID and the patternbgc to the desired color. For example:

Breakfast,"<bgc=\&h30c5a7/>burrito",4.99

**History**

2020 June, A-Shell 6.5.1682, CSV2XL :  Function added to A-Shell