Quick Start - Converting Files

 

See the on-line training videos also at:

http://www.softinterface.com/Convert-XLS/Documentation/Default.htm

images\ebx_356586637.gif

For every conversion job, you will need to take the following steps:

1)    Select the action to be done: Convert Files or Special Processing on files.

2)    Select the conversion method, 'MS Excel' or 'Convert XLS'. If you select MS Excel, you can choose any file that MS Excel can open. If you select 'Convert XLS' select the original file type.

Select the original file(s) to be converted from the "images\ebx_1332418670.gif File" or "images\ebx_-668700270.gif Folder" buttons. If you select a folder, you will need to specify the files completely by using the "D:\ORIGINALPATH\*.EXTENSION" format, where EXTENSION is the file extension of the files in the folder you've chosen to convert (e.g. D:\Sales\*.xls).

If you've specified an Excel file as the original file, next specify the sheet(s) to be converted either by name or number, and whether cell values or formulas should be in the resulting document by clicking the Options button. You may also specify a range and the delimitation/separation character in some cases.

3)    Select the target format you want to convert the Original file(s) to using the ‘Convert to File Format’ dropdown.

If converting multiple files, you may also elect to do subfolder conversions by checking the Do Subfolders box. This option is only available once a folder has been selected for conversion.

Specify a Target location to store the converted file(s)/folder. If the target folder doesn’t exist, 'Convert XLS' can create it for you. If you specified a whole folder of files to be converted, you will be expected to specify the target location completely by using the "D:\ORIGINALPATH\*.EXTENSION" format, where EXTENSION is the file extension of the Target Files (e.g. D:\Sales\August\*.xls).

4)    Press the Add button on the toolbar to add the task to the ‘Conversion Task List’. Repeat Steps 1- 4 as needed to add additional conversion tasks to the ‘Conversion Job’.

5)    Press the Convert button to begin the `Conversion Job'.

Repeat steps 1- 4 as many times as necessary to create a sophisticated ‘Conversion Job’. ‘Conversion Jobs’ can be saved, restored, and edited; they may also be specified and run from the command line.

If you would like to make changes to an entry that already exists in the Conversion Task list, highlight that entry by clicking on it. The entry-specific information will now be displayed in the text boxes. Make whatever changes are necessary then click the Update button in order to save those changes. Note that you are overwriting the existing information in the Conversion Task list for that task. If you would rather save the information as a new entry, simply click ‘Add’ and the original information will not be overwritten; rather a new, additional task will be added to the Conversion Task list.

See Also: Quick Start - Special Processing On Files

`Conversion Task'

`Conversion Job'

Putting It All Together

Editing a `Conversion Job'

Saving and Restoring a `Conversion Job'

Creating a New `Conversion Job'

Saving the Log as a `Conversion Job'