Not sure which of our tools to use? Click here for support.
It is compatible up to and including Office 97 through 2016 as well as Windows 2000 through Windows 10. Any Windows Server will work fine. Any Windows operating system 32 or 64 bit or greater will work.
Excel files created with the 'Convert XLS' conversion method may exhibit this issue. If this is the case then: For Office 2007 and greater you must add a TRUSTED LOCATION for those input files you are using.
The solution has nothing to do with the actual problem. Office now has some kind of "protected-mode" feature, which prevents office programs from doing certain things under certain conditions. - One of them is to stop excel from opening attachments coming from outlook. Go to Excel options, Trust Center, Settings, and uncheck all the options about "protected view".
'Convert XLS' is having difficulty opening the INPUT file. There may be several reasons for this. Try opening the input file from within MS Excel to see if it gives you an error. You may have to add a TRUSTED LOCATION if the INPUT file is not in a trusted folder.
MACROs have also been known to cause issues of this sort. Try disabling or deleting the MACROs in the INPUT file to see if that helps.
One of our online training videos illustrates how to do this. Briefly:
The secret is to have a 'master template Excel' file, let's call it Template.XLS. Template.XLS will have all the formatting you want, even formula's if you so desire, but it will be empty of data. You'll need to do the following steps:
You could optionally do it more elaborately:
Beginning with version 6.03 (May 24th 2012) of 'Convert XLS': Conversion of XLS/XLSX files that require a significant amount of time load data content or to calculate now have a new entry in the programs ini file, CX_SearchHistory.INI. To cause 'Convert XLS' to issue a RefreshAll() command and wait x number of milliseconds add this line immediately below the [frmMain] line:
For example, to delay 30 seconds (30000 milliseconds) it would look similar to this:
Yes, you can. Use the /K switch to get an error code. Here is a sample batch file.
Set ConvertXLS="C:\Program Files\Softinterface, Inc\ConvertXLS\ConvertXLS.EXE"
%ConvertXLS% /S C:\in\simple.csv /T"C:\in\simple.xlsx" /F6 /C51 /M2 /D /K /N"^^59" /L"C:\IN\LOG-FILE.LOG"
ECHO. The current errorlevel is %ERRORLEVEL%
if ERRORLEVEL 3 GOTO Label_Missing_Invalid_Arguements
if ERRORLEVEL 2 GOTO Label_Error_occurred_during_conversion
if ERRORLEVEL 1 GOTO Label_ECHO_SHAREWARE_EXPIRED
if ERRORLEVEL 0 GOTO Label_ECHO_SUCCESS
ECHO The conversion was successful
ECHO SHAREWARE EXPIRED
ECHO An error occurred during conversion, Use /V or /L for more info
ECHO Missing required or invalid command line argument(s)
Be certain you have the properly installed/setup language settings in the Control Panels\Regional Settings.
1. Run 'Convert XLS'
2. Press F3
3. Click the EDIT button
4. From within the text editor go to the FILE\SAVE AS menu item and when the dialog box opens up, note the folder location of where your fixed width profiles are stored.
5. You may exist the editor at this point.
6. Optionally: Copy the Profiles from the old to the new system using Windows Explorer
"'ConvertXLS' is not recognized as an internal or external command, operable program or batch file."
Important: To use the command line successfully you must do one of the following:
Set the path in your environment variables to the location of ConvertXLS.EXE
Use the full path in the command line (with double quotes) like so:
"C:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE" /S"C:\test\test.csv" /T "C:\test\test.xls" /C-4143 /F6 /M2 /V
If your original file begins with the letters "ID", your file will not convert to Excel. You need to move the letters "ID" out of the position where it is the first thing in the file to another location in the file.
For example, if your CSV file looks like this:
ID1234, comma, delimited, data
more, comma, delimited, data...
removing the ID, or placing it after the 1234 will fix the problem.
Convert the worksheet first to an HTML file, and give it a *.DOC extension. For example the target file should be something like:
And the target file type should be HTML.
The 'Convert XLS' conversion method supports the following file types.
Excel 5.0 BIFF5
Excel 7.0 (Excel 95) BIFF7
Excel 8.0 (Excel 97) BIFF8
Excel 9.0 (Excel 2000)
Excel 10.0 (Excel XP)
Excel 11.0 (Excel 2003)
XLS, XLSX files can be read for versions 2007 and higher.
Check the Excel Options (within MS Excel). See the advanced\Web Options\Encoding tab as shown below.