XLFormat - Copyright (C) 2003-2010, Incode Systems, Inc.
version 1.1.0 http://www.incodesystems.com mailto:salesUsage: [-Option] XLSFileName[.xls] [FormatFileName[.xlf]]
XLFormat uses Excel OLE Automation to format an XLS spreadsheet.
If FormatFileName is not given, default is XLSFileName with an .xlf extension
Options:
-H:HeaderFileName Tab delimited header file (multiple rows allowed)
(Default is DBF column names (MaxLength=10), use NUL for no header)
-H Force column heading row from ImportFileName (use with -H:)
-F:FormatFileName Tab delimited header file with Excel column formats
-FONT:FontName:Size[,Bold,Italic,Underline] Examples: -F:Arial:8 "-F:Arial Black:12,Bold,Italic"
-T:Title Example: "-T:Title for Printing~Second Line~Third Line"
-L Sets up printing for Landscape
-NoFreeze Suppress freezing header row(s)
-SubTotal:Key:Function:1,2,n
Key is the column number of the control column
Function is 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
ERRORLEVEL is 0 if Ok, or one of the following:
1 - FormatFileName not found
2 - Unable to overwrite XLSFileName
3 - Excel not found.
4 - Excel error.
5 - Too many rows.
Incode Systems, Inc.