XLS2File uses Excel OLE Automation to load XLSFileName
and save it as SaveAsFileName (Excel 97 or up must be installed).
If SaveAsFileName is not given, the fileName is XLSFileName.txt
If FileFormat is not given, FileFormat is determined by the extension.
The following tokens are used for FileFormat:
AddIn, CSV, CSVMac, CSVMSDOS, CSVWindows, DBF2, DBF3, DBF4, DIF,
Excel2, Excel2FarEast, Excel3, Excel4, Excel5, Excel7, Excel9795,
Excel4Workbook, IntlAddIn, IntlMacro, WorkbookNormal, SYLK,
Template, CurrentPlatformText, TextMac, TextMSDOS(default), TextPrinter,
TextWindows, WJ2WD1, WK1, WK1ALL, WK1FMT, WK3, WK4, WK3FM3, WKS,
Works2FarEast, WQ1, WJ3, WJ3FJ3, UnicodeText, Html
FileFormat may also be a number to allow use of future formats.
Options:
-! suppress tab file fix (removing double quotes)
(Excel double quotes columns containing commas when saved as a tab file)
-s:SheetName Select Sheet (example: "-s:My Sheet"
(If FileFormat applies to one sheet only, this option selects the sheet)
ERRORLEVEL is 0 if Ok, or one of the following:
1 - XLSFileName not found
2 - Unable to overwrite FileName
3 - Excel not found.
4 - Excel error.
5 - Invalid FileFormat.
6 - Excel sheet not found.
Incode Systems, Inc.