User Guide > Running a CL script

Extended or CATI licence

If you run a CL script with Companion, any CSV tables produced will be converted to a formatted Excel (.xlsx) with a table of contents provided you follow the following advice:

•The main script file (with the control stage) must use the extension .stpx

•Use RCP CSV2I. This will add info lines to the CSV output to help the formatting

•Do not use RCP OLDNAMES

•Do not use RCP O=

If the run fails or a CSV tables file was not produced, Companion will show the log file from the run.

If the run is successful Companion will open the created Excel file.

The programs used by Companion to view files will be the default ones for the file extension, usually:

For .txt files Notepad

For .xlsx files Excel

Spreadsheet options

When the CL run is finished and CSV tables were produced you will be presented with the Spreadsheet options window. You can change the settings now before pressing OK.

You can set the defaults using the menu:

[Analysis] [Default spreadsheet options] [Set global defaults] for every project/script.

[Analysis] [Default spreadsheet options] [Set local defaults] for this folder only (the one containing the opened project/script).

If there is a local default set this will be used in place of the global defaults.

Format options

You will only be shown the Format options window if you have not added the letter I (info) to the CSV2 RCP. This will contain only the formats that are relevant.