Please enable JavaScript to view this site.

A-Shell Consolidated Reference

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

AddComment

Add a cell comment.

AddFootnote

Add explanatory note at bottom of sheet.

AddLink

Create link from specified cell to footnotes.

AddSheet

Add or rename sheet.

DefineFont

Define a font and give it an identifier.

DefineFormat

Define a format and give it an identifier.

SetBanner

Add text and special formatting to line one.

SetCol

Set attributes for one or more columns.

SetDefaultFont

Set default font.

SetGroup

Create a row group.

SetIni

Override default ini file name.

SetOutputFormat

Override OutputFormat directive in ini file.

SetPrint

Set various print features.

SetRGBmode

Enable RGB color specifications.

SetRow

Set attributes for a row.