Please enable JavaScript to view this site.

A-Shell Consolidated Reference

 

//XL, SetCol, {colfirst=}<##>, {,collast=<##>} {,width=##} {,total|nototal} {,Common //XL Parameters}

Use SetCol to set attributes for a column or set of columns. Note that you have the option of referencing a previously defined format via the formatid=<formatid> parameter, in which case you should not specify any of the other font or format-related parameters. (A format includes a font.) Otherwise, you can specify any of the individual font and/or format parameters to effectively define the font and format on the fly.

Note that if the collast parameter is omitted, it is assumed to be the same as colfirst. If the first parameter is not named, it is assumed to be colfirst.

The SetCol directive(s) should be specified at the top of the file, before any data.

In the case of a multi-sheet workbook, any SetCol directives apply only to current sheet, and are reset by the next AddSheet directive. In the case, new SetCol directives can appear after each AddSheet directives but before any data lines but before any subsequent data lines.

Parameter total forces the 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.

Examples:

//;Set column 3 to bold

//XL,SetCol,3,bold

 

//;Set columns 4-6 to have yellow background

//XL,SetCol,colfirst=4,collast=6,FILLPATTERN_SOLID, patternfgc=COLOR_YELLOW

 

//;Set column 7 to use predefined format name fmtspecial

//XL,SetCol,colfirst=7,formatid=fmtspecial

 

History

2019 September, A-Shell 6.5.1668, CSV2XL.SBX edit 234:  Parameters total | nototal added.