CSV2XL 2.1(249) New //XL directive to support RGB colors:

//XL,SetRGBMode {,rgbmode=boolean}

The AXL library always starts out in color index mode (rgbmode=false), meaning that colors must be specified via the COLOR_xxx index values. Using this directive, with rgbmode=true (or omitting the parameter entirely), switches the library over to RGB mode, in which colors are specified using the hex format &hbbggrr. For example:

hello,"<fontcolor=&hff99cc,bold/>Bonjour",Hola

You can continue to use COLOR_xxx indices in RGB mode, as they can be converted unambiguously by the AXL library functions. But the reverse is not supported, i.e. you cannot specify RGB values when not in RGB mode.

Comments

•   RGB mode is only supported with XLSX format, not XLS

•   If using the AXL library functions directly, you must recompile with LIBXL.BSI edit [138] or higher and LIBXL2.BSI [103] or higher.

•   Attempts to specify colors that are incompatible with the mode will result in a warning message in the debug message window.