Please enable JavaScript to view this site.

A-Shell Reference

COMMAND=SBX:CSV2XL{,inifile}

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

CSV2XL.SBX converts CSV files to XLS format. It is packaged 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. In addition to the calling parameters specified below, the operation of CSV2XL is controlled by the CSV2XL Initialization File and the CSV2XL Directives.

The first syntax above shows CSV2XL being used as a print filter—i.e., within a printer ini file. The second shows it being used as an ordinary SBX—i.e., from an application.

For more information on the benefits of creating XLS as opposed to CSV files, and some of the features of CSV2XL, see Benefits of XLS Files and CSV2XL.

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 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.

 

Subtopics

CSV2XL Ini File

CSV2XL Directives

Notes on Syntax

Common //XL Parameters

Cell-Level Attributes

Masks

CSV2XL Examples

Benefits of XLS Files and CSV2XL

Number Formats

CSV2XL Notes and Tips