Updated May 2023
To assert greater control over details of the output file formatting, you may optionally insert //XL directives into the CSV file. These should be at the top, before any data lines, except in the case of the //XL,SetRow directive, which may be inserted anywhere above the affected row(s).
The syntax for the //XL directives is a bit tricky, and differs from normal A-Shell conventions. See Notes on Syntax.
Directive |
Operation |
|---|---|
Add a cell comment. |
|
Add explanatory note at bottom of sheet. |
|
Create link from specified cell to footnotes. |
|
Add or rename sheet. |
|
Override Totals directive in ini file. |
|
Define a font and give it an identifier. |
|
Define a format and give it an identifier. |
|
Merges cells. |
|
Override AppendSeqno directive in ini file. |
|
Add text and special formatting to line one. |
|
Set attributes for one or more columns. |
|
Set default font. |
|
Create a row group. |
|
Override default ini file name. |
|
Override Launch directive in ini file. |
|
Override OutputFormat directive in ini file. |
|
Forces page break at specified location. |
|
Set various print features. |
|
Enable RGB color specifications. |
|
Set attributes for a row. |
|
|
|
|
