1702.2.3

CSV2XL.SBX 2.1(263) supports two minor enhancements to existing INI file options:

•   SendToPC=2 forces the file transfer to use the ATE-specific non-FTP transfer protocol. This is useful in environments where (S)FTP is not supported. Option 1 continues to use (S)FTP if the server is not Windows and the file is larger than about 10K.

•   SaveToDir now supports AMOS-style directories, including ersatz. Previously it only supported native directory notation. If the directory does not exist and cannot be created, it will be ignored.

1682.0.5

CSV2XL 2.1(250) Enhancement - new directive:

//XL,SetOutputFormat,<format>

This directive overrides the OutputFormat directive in the INI file. The two <format> options in either case are XLS and XLSX. As with the SetINI directive, it has to appear in the CSV source file prior to any lines that do not start with //XL.

1682.0.4

Add new CSV2XL Directive SetRGBmode.

1682.0.3

Add CSV2XL Support for Cell-Level Attributes.

1672.0.2

CSV2XL.SBX 2.1(244) enhancement to the SetBanner directive: you may now embed an explicit line break by inserting "^M" into the text, in which case the height of the banner will be increased accordingly. Unlike the column headers, the banner does not typically wrap and increase in height automatically, at least under most versions of Excel, apparently due to complications with the cell merging used to spread the banner across all the columns.

1682.0.2

CSV2XL 2.1(247) The SetRow directive now supports setting attributes (such as colors) for the next row or a specified set of rows yet to be output. Also, fix an apparently intermittent issue with the total and nototal parameters on the SetCol directive.

1682.0.1

XTREE enhancement: export to XLSX via CSV2XL now supports colors.

1671.4.2

Add CSV Directive SetGroup in CSV2XL.2.1(243)

1671.0.2

Add CSV2XL Directive AddFootnote to CSV2XL.

1668.0.9

Add CSV2XL Directive SetBanner to CSV2XL 2.1(238).

1668.0.7

CSV2XL 2.1(236) refinement to the AddSheet directive: extension may now be eliminated from the directive in order to allow the current output format to set the standard extension. Previously you had to specify either xls or xlsx which would then cause problems if the actual format didn't match.

1668.0.5

CSV2XL 2.1(234) Enhancement: new parameters to the //XL,SetCol directive:

total: forces column to be totaled

nototal: disables totals for the column

These override the ColTitleTextRegex directive in the CSV2XL.INI file, as well as the default rules, which are to total numeric columns.

1668.0.4

CSV2XL 2.1(233) Enhancement - New directive:

//XL,AddComment,row=##,col=##,text=text{,width=pixels}{,height=pixels}

Note that as of LIBXL 3.8.5, this directive is ignored for XLSX format, i.e. is only supported for XLS format.

1661.3.4

CSV2XL.SBX 2.1(232): add hcenter and vcenter options to the //SetPrint directive, e.g. //SetPrint, vcenter{=1},hcenter{=1}. Note that the =1 is optional (1 for on, 0 for off), but since there is little reason to ever specify the attribute except when turning it on, it isn't really necessary to specify the attribute value.

1661.0.4

CSV2XL.SBX 2.1(230) enhancements:  //XL,AddSheet now supports an optional parameter COLOR=COLOR_xxx to set the tab color; set wrap attribute for column headers.

1660.6.2

Add CSV2XL Print Directive SETPRINT to CSV2XL.SBX 2.1(227), to set print features.

1655.1.1

Refinements/enhancements to the //XL, AddSheet directive.