Note that "^m" or "^M" can be inserted into data cells, as well as column headers and banners, to force line breaks and increase the row height accordingly.
CSV files can use comma, tab, or pipe delimiters, but //XL directives must use comma delimiters, and therefore any parameters containing commas must be quoted.
The following macros may be used as attribute values in //XL statements, referencing the INI attribute value of the same name:
$HEADERSFG |
$HEADERSBG |
$TOTALSFG |
$DEFAULTFONT |
$DEFAUULTFONTSIZE |
$DATEFORMAT |
$TIMEFORMAT |
$DATETIMEFORMAT |
For example, to specify the INI-defined headers background color as the background for a particular column ...
//XL,SetCol,colfirst=7,width=2,bgc=$HEADERSBG
History
2025 February, A-Shell 1769.0 CSV2XL 2.2(300): Added macro support as described above.
2025 January, A-Shell 1768.4, CSV2XL 2.2(296): updated to support the latest LIBXL.DLL 4.5.0.
2023 October, A-Shell 1750.2, CSV2XL 2.2(291): add support for 64 LibXL library, which is required when running on 64 bit versions of A-Shell.
2023 February, A-Shell 6.5.1724, CSV2XL.SBX 2.1(268): A literal "^m" inside a data field now makes the expected adjustments to the spreadsheet configuration—i.e., activating the wrap option and increasing the row height. This was previously supported in the column headers only.
