Printer Initialization Directive:
COMMAND=SBX:CSV2XL{,inifile}
Subroutine:
xcall CSV2XL, sts, fspec {, printer, switches, copies, form, inifile }
System Command:
CSV2XL fspec {,inifile}
CSV2XL.SBX converts CSV files to XLS{X}* 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{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. |
* AXL, including CSV2XL, supports both the old Excel file format XLS and the new 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.
See Also
ׇ• | AXL: Lower level functional interface for reading and writing XLS{X} files |
Subtopics