Quick Start - Special Processing on Files

If after reading this you need more guidance, see the on-line training videos at:

www.softinterface.com/Convert-XLS/Documentation/

Special Processing on Files allows you to select one of the various ‘Special Process’ options and apply it to a file. Special processes include these general categories:

· Excel file manipulations

· CSV file manipulations

· Text, RTF, HTML and MS Word file manipulations

· Executing another application

$images\ebx_914699699.gif$

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

(1) Select Special Processing on Files as the action to do.

(2) Select the Special Process. Select the File Format of the input files(s).

(3) Select the input and output file(s) to be processed from the “ $images\ebx_1332418670.gif$ File” or “ $images\ebx_-668700270.gif$ Folder” buttons.

(4) Click the Click here for Options button at this time to specify items such as sheets, ranges, delimitation/ separation character, fixed width profiles etc. Note that the button caption changes for each special process chosen.

(5) Optional: If you are going to specify more than one special process or conversion item, 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'.

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 run from the command line and built in scheduler. See the File menu to save or restore a conversion job.

Processing whole folders

Use the wild card syntax to specify a whole folder to process. For example to process all the XLS files in the c:\IN\ folder you would specify c:\IN\*.XLS.

$images\ebx_1093943416.gif$ The Quick Launch Buttons

Quick launch buttons are extremely helpful. They are located immediately to the right of the input and output file specification area and when clicked they will open the files specified in their default editor. If a folder is specified the quick launch button will open Windows Explorer using that specific folder for your review. Use these buttons to check the content of the input and output file/folders before or after conversions.

Modifying items in the task list

If you would like to make changes to an existing conversion item in the conversion task list, highlight that entry by clicking on it (double click for options associated with the item). The details associated with the item will be displayed in the upper portion of the user interface. 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 specific task. If you would rather save the information as a new entry, simply click the Add button and the original information will not be overwritten, rather a new, additional task will be added to the conversion task list.

Using non-standard file extensions

If your input or output files do not use standard file extensions you will have to specify the file type in the input or output file format drop down list box. For example if your Excel files are named MyExcelFile.ABC instead of MyExcelFile.XLS you must specify the file type.