Incode Systems Home Page Incode Systems, Inc.

Excel Automation products

XLImport

XLImport is a command line utility (generally run in a Command Prompt in Windows, or from a Batch File) which allows for completely automated, unattended importing of text files (tab delimited) into either an existing Excel spreadsheet or a new one.

XLImport essentially automates the process of manually using Excel to import an external text file. This can be a very powerful tool for users who need to repeatedly create spreadsheets from source text files, including when they want specific formatting for individual columns.

XLImport also is capable of specifying a Total function that builds a new row at the bottom of the data, and also to invoke Excel's SubTotal feature.


Example Usages:

Simplest usage; imports test.txt into a plain test.xls with no extra formatting, etc. This is equivalent to performing a manual import with Excel, as are most of the methods of using XLImport.
XLImport test.txt test.xls
This example sets the sheet name and requests a SubTotal be defined to Sum column 4 at every change in column 1.

XLImport "-SN:My Sheet Name" -SubTotal:1:Sum:4 test.txt test.xls

You can view the full usage (all options are described) for the current version at this page.

XLImport requires Microsoft Excel to be installed on the same PC. It has been tested on Windows 95+ and Excel 97 through 2010.


Incode Systems also offers these Excel utilities that you may find useful. See their usage and details here:


To receive a license to use these products, we require you to purchase 1 month of email support for the product. This gives you a license to use this product on a single computer indefinitely. Our regular price for this 1 month of support is $50, but we have a limited time price of $25.

Contact us here to get this product.

The software offered on this page is commercial copyrighted software licensed to the user by Incode Systems, Inc. (ISI).
While there is currently no cost to obtain this software, ISI does not guarantee that this software will always be available at no cost.
Furthermore, ISI assumes no liability whatsoever for any problems incurred through the use of this software.
USE AT YOUR OWN RISK. See License for details.

[Home]