Specifying a 'Conversion Job' File

The first thing to be done is to create the conversion job file. Basically, within the user interface you detail each conversion task and add it (pressing the Add button) to the task list. Once you are satisfied with the task list, save the conversion job file from the File menu. Before saving, be sure that you press the Rewind button to ensure that the entire task list is executed from the command line.

The syntax for specifying a 'Conversion Job' file is:

ConvertXLS /J{ConversionJobFile} [/V] [/L{LogFile}] [/B{LogToJobFile}] [/W{PW}] [/X{PW}] [/Y{PW}] [/Z{PW}]

Items above enclosed in square brackets "[ ]" are optional, all other switches are required. Therefore /J should always be specified on the command line.

Command line switches are case sensitive, therefore /J is valid and /j will not work.

You can include or exclude spaces between switches and parameters. For example, "/C6" is the same as "/C 6".

For long file names (path contains spaces) you may be required to use double quotes. For example:

ConvertXLS.exe /J "C:\My Jobs\To Convert Daily.SII"

Switches:

/J{ConversionJobFile} is the name of the Conversion Job previously created within the graphical user interface.

[/V] Verbose mode. Specify this switch to display a message box indicating success or failure after the job has run. If a failure occurred a reason is usually displayed. See also /L.

[/L{LogFile}] Log file path and name (e.g. d:\mylogs\MoreInfo.LOG). If this switch is specified a log file with the given path and name will be created and the results of the conversion will be written to it. See also /V.

[/B{LogToJobFile}] Save the Log file as a 'Conversion Job', but only if errors occurred. This is useful if the files that had problems can be done at a later time, or with a different method. /B is different from /L, since the file generated with /B will not include extraneous comments not allowed in a 'Conversion Job' file. Specify the file name with *.SII file extension so it can be loaded as a conversion job (e.g. /B"C:\Out\Issues.SII").

[/W{PW}] [/X{PW}] [/Y{PW}] [/Z{PW}] Passwords for opening Excel files. See All Command Line Switches for more information.

Example:

To run the 'Conversion Job' specified by the "C:\MyJobs\ApplesOranges.SII" type the following in at the 'Command Prompt':

ConvertXLS.EXE /J"C:\MyJobs\ApplesOranges.SII"