SQL2XLSx - Copyright (C) 2003-2004, Incode Systems, Inc.
version 0.9 http://www.incodesystems.com sales [at] incodesystems.com
Usage: [-Option] InputFileName[.sqx] [XLSFileName[.xls]]
SQL2XLSx uses Excel OLE Automation to create an XLS spreadsheet from the output
of an SQL statement.
If XLSFileName is not given, InputFileName is used with an .xls extension.
Options:
-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"
-O:from SQL (default), 1=Tab from SQL, 2=XLS from Tab
-CS=string
-D=Source Name
-U:Do NOT Print Gridlines (default)
-H:HeaderFileName Tab delimited header file (multiple rows allowed)
(Default is column names from SQL result set)
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.
-L Sets up printing for Landscape
-NoFreeze Suppress freezing header row(s)
-R Run spreadsheet when creation is complete.
-SN:SheetName (default is InputFileName 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.
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.
SQL2XLSx - Copyright (C) 2003-2004, Incode Systems, Inc.
version 0.9 http://www.incodesystems.com sales [at] incodesystems.com
To read complete help type: SQL2XLSx | MORE
Incode Systems, Inc.