1772.1.6 |
CSV2XL.SBX 2.2(307) supports up to 4 additional format directives to associate formats with column titles. Unlike the otherwise similar ColTitleTextRegex# directives, these are each independent, associating a a pattern with a format: ColTitleFormatRegex1=format,pattern ColTitleFormatRegex2=format,pattern ColTitleFormatRegex3=format,pattern ColTitleFormatRegex4=format,pattern As with the NumFormat directive, the format may be either a predefined NUMFMT_xxx symbol or a mask; see the //XL,SetCol directive for details. Note that unlike most other directives, these take two arguments, separated by a comma. If either the format or the pattern contains commas, you must enclose it in quotes, e.g.: ColTitleFormatRegex1="##,###.00[red]##,###.00",Amount|Total|Price|Value |
1772.1.2 |
CSV2XL.SBX 2.2(304) supports a new NumFormat item in the [FORMAT] section of the CSV2XL.INI file to define the default format to use for columns that are purely numeric (instead of NUMFMT_GENERAL) and are not otherwise defined via //XL,SetCol directives. There are two variations: NumFormat=NUMFMT_xxx NumFormat=mask The first variation uses the pre-defined NUMFMT_xxx symbols, for example: NumFormat=NUMFMT_NUMBER_SEP_D2 The second variation specifies a mask according to the specification for the mask parameter of the SetCol directive. For example: NumFormat=##,###,###.00;[Red]##,###,###.00 Note that for columns that are purely numeric, but which you want to leave unformatted (such as account numbers, zip codes, etc.), you can use the ColTitleTextRegex=pattern directive to exclude them from the NumFormat format based on the column title. |
1772.1.3 |
CSV2XL.SBX 2.2(305) expands the number of ColTitleTextRegex directives from 1 to 9 to make it easier to edit a long pattern list in the INI file. The maximum combined length remains 500 characters, but you can now break it up, e.g. ColTitleTextRegex=zip|(part *(no|num|#))|phone|sku|invno|wo|code|po ColTitleTextRegex2=acct *(no|num|#)|status|icd| ColTitleTextRegex3=diag|m\d|diag\d ColTitleTextRegex4=street #|house # ColTitleTextRegex5=Dept#|^id|^prov|^loc|^pos ... ColTitleTextRegex9=Numero|Cantidad
Note that it doesn't matter whether each line ends with a pipe (|) or not; they will be concatenated with pipe separators as required. |
1772.1.4 |
CSV2XL.SBX 2.2(306) now 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. |
1769.0.2 |
Add CSV2XL directive MergeCells. |
1769.0.3 |
Add CSV2XL directive SetPageBreak. |
1769.0.4 |
Add attributes to CSV2XL directive SetPrint. |
1769.0.5 |
Add support in CSV2XL for using macros as attribute values. |
1769.0.6 |
Add CSV2XL directives SetLaunch and SetAppendSeqno. |
1769.0.7 |
Add CSV2XL directives AddTotals, SplitRow, and SplitCol. |
1769.0.8 |
Add refinements to the CSV2XL directive AddSheet. |
1750.2.2 |
CSV2XL 2.2(291) enhancement: add support for 64 LibXL library, which is required when running on 64 bit versions of A-Shell. |
1739.0.6 |
CSV2XL.SBX 2.1(286): SetBanner now supports the fontname and fontsize attributes, e.g.: //XL,SetBanner,text="This is a Banner",fontheight=20,fontname=Broadway |
1730.0.3 |
CSV2XL.SBX 2.1(279) adds CSV2XL Directive AddLink to create link from specified cell to footnotes. |
1730.0.2 |
CSV2XL.SBX 2.1(277) adds CSV2XL Footnote Subscripts to enable footnote subscripts. |
1731.0.1 |
CSV2XL.SBX 2.1(275): CSV source files using TAB or pipe (|) delimiters are now supported. |
1730.1.9 |
CSV2XL.SBX 2.1(281) adds several CSV2XL Refinements. |
1730.1.10 |
CSV2XL.SBX 2.1(282) adds additional CSV2XL Refinements. |
1725.0.4 |
CSV2XL.SBX 2.1(269): Extend limit on individual //XL parameters from 256 to 512 characters. This was mainly an issue for footnotes and possibly banners, which can get quite lengthy. |
1724.2.2 |
CSV2XL.SBX 2.1(268): A literal "^m" inside a data field now makes the expected adjustments to the spreadsheet configuration (activating the wrap option and increasing the row height). Note that this was previously supported in the column headers only. |
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) adds new directive to control output format: //XL,SetOutputFormat,<format> This directive overrides the OutputFormat directive in the INI file. The two format options 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 |
CSV2XL 2.1(249) adds CSV2XL Directive SetRGBmode to support RGB colors. |
1682.0.3 |
CSV2XL 2.1(248) adds 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 |
CSV2XL.2.1(243) adds CSV2XL Directive SetGroup. |
1671.0.2 |
CSV2XL adds CSV2XL Directive AddFootnote. |
1668.0.9 |
CSV2XL 2.1(238) adds CSV2XL Directive SetBanner. |
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) adds 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) adds 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 |
CSV2XL.SBX 2.1(227) adds CSV2XL Print Directive SETPRINT to set print features. |
1655.1.1 |
Refinements/enhancements to the //XL, AddSheet directive. |
