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
