Incode Systems Home Page Incode Systems, Inc.

Saturday, April 11, 2009 1:25 pm CDT

XLImport 0.96.1

XLImport uses Excel OLE Automation to import a tab-delimited text file to an XLS file. Prior versions overwrote existing XLS files. The new version adds a new sheet (tab) to an existing XLS file. In addition, two new options allow specifying the print options "Pages Wide" and "Pages Tall".

XLImport - Copyright (C) 2003-2009, Incode Systems, Inc.
version 0.96.1 http://www.incodesystems.com mailto:sales1@incodesystems.com

Usage: [-Option] ImportFileName[.txt] [XLSFileName[.xls]]

XLImport uses Excel OLE Automation to import a tab-delimited text file to an
XLS file. If the file exists, a new sheet is created for the imported sheet.
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).
-AS  Appends rather than prepends new sheet to existing XLS file.
-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"
-G  Print Gridlines
-G- Do NOT Print Gridlines (default)
-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)
-PW:n Print n pages wide (use 0 for not defined)
-PT:n Print n pages tall (use 0 for not defined)
-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-2009, Incode Systems, Inc.
version 0.96.1 http://www.incodesystems.com mailto:sales1@incodesystems.com

To read complete help type: XLImport | MORE

[Home]