Incode Systems Home Page Incode Systems, Inc.


XLData



(Windows 95 or higher)

XLData - Copyright (C) 2007-2012, Incode Systems, Inc.
version 0.96 http://www.incodesystems.com mailto:sales1Usage: [options] XLSFileName[.xls] DataFile

XLData uses Excel OLE Automation to load XLSFileName
modify cells with data contained in DataFile and save.

XLSFileName is the name of the XLS file to be modified.
DataFile is the name of a tab-delimited text file.
The first column is the cell location to modify (example: A1).
If cell is not given, the cell immediately below the previous
cell is used. Text values which could be interpreted by Excel
as numbers should be preceeded with a single quote character,
just as when entered manually.
XLData by default checks the Active Sheet and the selected cell
when it starts, and restores these values when it exits.

Options:
-as- Do not AutoSave XLS file (default is to save)
-h skip header line in DataFile
-o Open in Excel
-rr- Do not restore Selected Range (default is to restore)
-rs- Do not restore Active Sheet (default is to restore)
-s:SheetName Select Sheet (example: "-s:My Sheet")
(If SheetName is not given, default is active 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 - DataFile cannot be read.
6 - Excel sheet not found.

XLData - Copyright (C) 2007-2012, Incode Systems, Inc.
version 0.96 http://www.incodesystems.com mailto:sales1(to view entire help, type: XLData | MORE)