Please enable JavaScript to view this site.

A-Shell Reference

CSV2XL converts CSV files to file in the XLS{X} format. It is written in ASB and compiled as a subroutine (CSV2XL.SBX). It is structured as a print filter, which means that it can be called automatically via the printer ini file COMMAND=SBX:CSV2XL interface, but, like all print filters, can also be called directly from an application. A convenient System Command version is also provided.

In addition to the calling parameters specified below, the operation of CSV2XL is controlled by series of directives. Some of these directives apply to all spreadsheets all of the time, while other directives apply only to the current spreadsheet. Accordingly, they are divided into INI File Directives and CSV File Directives, which see for full information.

Print filter syntax (within a printer ini file):

COMMAND=SBX:CSV2XL{,inifile}

System Command syntax:

CSV2XL fspec {,inifile}

Subroutine syntax:

xcall CSV2XL, sts, fspec {, printer, switches, copies, form, inifile }

Parameters

Parameter

Type

I/O

Description

sts

B,1

Out

Normally used to signal to the caller whether to it should print the file after processing by the filter. Currently not used since XLS{X} files are generally not printed directly.

fspec

String

In

The source file spec, e.g. xxx.csv

printer

String

In

Not applicable here.

switches

Num

In

Not applicable here.

copies

Num

In

Not applicable here.

form

String

In

Not applicable here.

inifile

String

In

Specifies the ini file to use; default is BAS:CSV2XL.INI.

 

See Also

All of the other topics in the "Other CSV2XL Topics" section