Empower yourself with File Comparison and File Conversion tools from Softinterface. Leverage technology to automate your work.

'Convert XLS' Solutions Forum - Command Line
 The Comprehensive Excel Conversion Utility

 

Here are some examples of command line jobs.  Additional examples and a full discussion of using the command line can be found on-line in the documentation. 

NOTE: A mistake most commonly made when constructing a command line is confusing the file type constants for SPECIAL PROCESSES and the file type constants for CONVERSION (switches /F# and /C# for original and target file type constant respectively).  Be certain you are using the appropriate constants. The documentation contains the constants.

Job Description

How It Does It

Command Line
Convert a CSV file to an XLS file using 'Convert XLS's built in conversion algorithm (MS Excel is NOT required). Specify original file (/S E:\TryMe.CSV) type as CSV (/F6) and the target file (/T E:\Tryme.XLS) type as XLS (/C-4143).  Use the 'Convert XLS' conversion method (/M2). ConvertXLS /SE:\TryMe.CSV /F6 /T E:\Tryme.XLS /C-4143 /M2

Convert a semicolon delimited file to a comma delimited file

Specify original file type as csv (/F30); run special process 75 (/P75) to replace a character.  Character to replace (/1) is ASCII character 59, a semicolon.  Replacement character (/2) is ASCII character 44, a comma.

 ConvertXLS /F30 /S"E:\TryMe.txt" /T"E:\Output.TXT" /P75 /1 59 /2 44

 

Copyright © 1999-2008 by SoftInterface, Inc. All rights reserved.