Incode Systems Home Page Incode Systems, Inc.


XLS2FILE



(Windows 95 or higher)

XLS2File - Copyright (C) 2003-2012, Incode Systems, Inc.
Version 1.1.0 www.incodesystems.com mailto:sales1Usage: [options] XLSFileName[.xls] [SaveAsFileName] [FileFormat]

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
Excel 2007 and up: OpenXML, OpenXMLM, Excel12, PDF, WebArchive

FileFormat may also be a number to allow use of future formats.
If your version of Excel does not support the FileFormat, Excel error
is returned and ERRORLEVEL is 4.

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)
-ul:n update links (default is 0 to NOT update links, 3 updates links)
(warning: if -ul:3 is used and data is not found, a dialog will open)

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.

XLS2File - Copyright (C) 2003-2012, Incode Systems, Inc.
Version 1.1.0 www.incodesystems.com mailto:sales1(to view entire help, type: XLS2File | MORE)