| • | An "^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
| • | , CSV2XL assigns the format NUMFMT_TEXT to columns with no data in the first 20 rows unless explicitly set via a //XL,SetCol directive. Previously they got the NUMFMT_GENERAL format which may have resulted in meaningless subtotals. |
History
2025 May, A-Shell 1772, CSV2XL.SBX 2.2(306): Added NUMFMT_TEXT formating as described above.
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.
