XLImport uses Excel OLE Automation to import a tab-delimited text file to an
XLS spreadsheet.
If XLSFileName is not given, ImportFileName is used with an .xls extension.
Options:
-@ParmFileName ParmFileName is the name of a text file containing
one parameter per line. Parameters on the command line containing spaces
should be surrounded by double quote characters. Lines in ParmFile should not.
HeaderFile may be embedded in ParmFile by surrounding the file lines with:
[HeaderFile]
[/HeaderFile]
FormatFile may be embedded in ParmFile by surrounding the file lines with:
[FormatFile]
[/FormatFile]
-AF- Suppress AutoFit (automatic column width).
-F:FormatFileName Tab delimited file with Excel column formats
example: #,##0.00 (see Excel Custom formats for details
If format ends with ~9.25, column width is set to 9.25
-FONT:FontName:Size[,Bold,Italic,Underline] Examples:
-FONT:Arial:8 "-FONT:Arial Black:12,Bold,Italic"
"-FONT:Arial Black:12,Bold,Italic"
-H:HeaderFileName Tab delimited header file (multiple rows allowed)
(Default is column names from first row of ImportFileName)
Columns preceeded with > are merged and centered
Columns preceeded with _ are merged, centered, and underlined
Columns preceeded with are centered
Columns preceeded with < are WrapText. centers and wraps.
-H- ImportFileName contains no header row.
-L Sets up printing for Landscape
-NoFreeze Suppress freezing header row(s)
-R Run spreadsheet when import is complete.
-SN:SheetName (default is ImportFileName without the extension)
-SubTotal:Key1:Function:1,2,n;Key2:Function:1,2,n
Key is the column number of the control column
Functions:
Sum,Count,Average,Max,Min,Product,CountNums,StdDev,StdDevP,Var,VarP
1,2,n are the column numbers to be subtotaled
Note: there are no spaces between any characters in the Subtotal parameters
-T:Title Example: "-T:Title for Printing~Second Line~Third Line"
-TL: Title Example: "-TL:Left Title for Printing" (default: run time
-TR: Title Example: "-TR:Right Title for Printing" (default: Page 1 of 5)
-U- Suppress column heading underline.
Column formats are derived from the first line of ImportFileName
or the last line of HeaderFileName if -H- option used.
Column name ends with a tilde (~) followed by a format number (ex: MyCol~2):
General Format = 1
Text Format = 2
MDY Date Format = 3
DMY Date Format = 4
YMD Date Format = 5
MYD Date Format = 6
DYM Date Format = 7
YDM Date Format = 8
Skip Column = 9
If no format is given with the column name, General Format is used.
ERRORLEVEL is 0 if Ok, or one of the following:
1 - ImportFileName not found
2 - Unable to overwrite XLSFileName
3 - Excel not found.
4 - Excel error.
5 - Too many rows.
XLImport - Copyright (C) 2003-2004, Incode Systems, Inc.
version 0.94 http://www.incodesystems.com sales [at] incodesystems.com
Incode Systems, Inc.