Various of the CSV2XL directives allow you to specify colors for text and background. You may so specify by using one of the two methods described below.
Color Index
CSV2XL's native color reference system is a list of colors with associated common names. You can see the colors and their names here.
Using the native scheme to set the headers background color, for example, you would write:
HeadersBG=COLOR_GRAY25
This index is the default color definition scheme, and will be used and expected unless you change it to RGB.
RBG Mode
If you prefer to use RGB color terminology, for example:
HeadersBG=&hff99cc
...you can do so by shifting CSV2CL into 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 [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 System Messages window. |
| • | RGB mode is automatically activated if any color parameter in the INI file is specified in terms of a hex value, e.g. |
HeadersBG=&hd0e0f0
| • | If you are in RGB mode, you can specify colors with the index designations; they will be recognized by the AXL library functions. However, the reverse is not true; you cannot specify RGB values when not in RGB mode. |
Entering / Exiting RGB Mode
As mentioned above, the native color selection mode is the CSV2XL color index. To use RGB colors, you need to go into RGB mode, which you can do in two ways.
From within the INI file:
SetRGBMode={boolean}
From within the CSV file:
//XL, SetRGBMode {,rgbmode=boolean}
To exit RGB mode and return to the index method:
//XL, SetRGBMode 0
History
2019 June, A-Shell 6.5.1682, CSV2XL.SBX edit 249: RGB mode added to CSV2XL.
