Modified December 2019; see History

//XL, SetBanner, text=<banner text>

When set, the banner occupies the first row of the spreadsheet, above the headers, with the text centered in a bold 12 point font. All of the columns are merged so at to make a single wide column for the banner. This is a good way of displaying a spreadsheet title or other identifying information about the spreadsheet, such as dates, selection criteria, etc.

Note that the SetBanner directive, if used, must appear after any AddSheet directive and before the headers. For example:

//XL,AddSheet,sheetname=Frozen,color=COLOR_CORAL_CF

//XL,SetBanner,text=Frozen Aged Inventory as of 09/21/19

Code,Description,Qty,NetWt,0-6,7-13,14-20,21-27,28-34,35+

//XL,SetCol,colfirst=5,collast=10,width=7,formatid=NUMFMT_NUMBER_SEP

...

Note also that you may 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.

History

2019 December, A-Shell 6.5.1672, CSV2XL.SBX 2.1(244):  Add ^M for line break.