Please enable JavaScript to view this site.

A-Shell Consolidated Reference

 

 

AddComment

//XL, AddComment, row=##, col=##, text=text {,width=pixels} {,height=pixels}

As of A-Shell 6.5.1668, this directive is ignored for XLSX format—i.e. is only supported for XLS format.

 

 

DefineFont

//XL, DefineFont, {fontid=}<fontid>, {name=<name>} {,size=<pointsize>} {,color=COLOR_xxx} {,Common //XL Parameters}

Define a font and give it an identifier which can then be used in a subsequent DefineFormat directive. This is only necessary when you want to use the same font in multiple formats, columns or rows. Otherwise, you can specify the font attributes directly when defining the format or setting the column or row attributes.

Examples

//;Define bold green font, assign fontid “bold_green” 

//XL,DefineFont,fontid=bold_green,bold,COLOR_GREEN

 

//;Define 14 Courier font, name it “courier14” 

//XL,DefineFont,fontid=courier14,fontsize=14, fontname=Courier New

 

 

DefineFormat

//XL, DefineFormat, {formatid=}<formatid> {,Common //XL Parameters}

Define a format and give it an identifier which can then be used in a subsequent SetCol and SetRow directives. This is only necessary when you want to use the same format in multiple columns or rows. Otherwise, you can specify the format attributes directly in the SetCol and/or SetRow directives.

Examples

//;Define format named “fmtx” using bold_green font 

//XL,DefineFormat,formatid=fmtx,fontid=bold_green,ALIGNH_CENTER

 

//;Define format named “fmtpink” with pink bg, bold violet text 

//XL,DefineFont,formatid=fmtpink, FILLPATTERN_SOLID, patternfgc=COLOR_PINK, bold, fontcolor=COLOR_VIOLET

 

 

SetDefaultFont

//XL, SetDefaultFont {,fontname=<fontface>} {,fontsize=<pointsize>}

Establish the default font face and size to be used by the spreadsheet app.

Example

//XL,SetDefaultFont,fontname=Courier New,fontsize=12

 

 

SetIni

//XL, SetIni, <inifile>

Establishes the name of the ini file, overriding the one specified in the printer initialization file or subroutine. This directive can only appear once in a source file, and must appear at the top, before any data lines.

Example

//XL,SetIni,BAS:CUSXLS.INI

 

 

SetOutputFormat

//XL,SetOutputFormat,<format>

This directive overrides the OutputFormat directive in the ini file. The two <format> options in either case 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.

 

 

SetRow

//XL, SetRow, {row = #} {,rowfirst=#} {,rowlast=#} {,height = #} {,Common //XL Parameters}

Set attributes for a row or group of rows. The first row is considered row 1, whether it contains headings or data. It should be specified before the affected data rows. If the none of the row* parameters are specified, the directive affects the next row to be output. To specify all rows, set rowlast to a number greater than the actual number of rows (e.g. 999999).  Height is set in typographical points. The directive also supports setting attributes (such as colors) for the next row or a specified set of rows yet to be output.