CSV2XL converts CSV files to file in the XLS{X} format CSV2XL supports both the old Excel file format XLS and the current file format XLSX. All references in this documentation to one or the other file formats should be understood to apply equally to the other format, unless explicitly stated otherwise. It is written in ASB and compiled as a subroutine (CSV2XL.SBX). 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 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}
Subroutine syntax:
xcall CSV2XL, sts, fspec {, printer, switches, copies, form, inifile }
System Command syntax:
CSV2XL fspec {,inifile}
For more information on the benefits of creating XLS{X} as opposed to CSV files, and some of the features of CSV2XL, see Benefits of XLS{X} 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{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 |
In |
Not applicable here. |
|
copies |
In |
Not applicable here. |
|
form |
String |
In |
Not applicable here. |
inifile |
String |
In |
Specifies the ini file to use; default is BAS:CSV2XL.INI. |