XLSConverterX is an ActiveX component designed to assist you, the developer, in quickly adding an Excel conversion/manipulation utility to your applications. XLSConverterX is designed to manipulate comma delimited CSV, and MS Excel (and any files MS Excel can open) files. A tool like this can be very helpful when you need to move, convert or manipulate Excel like data. HTML, Text, RTF and CSV are available for conversion as well as several database formats and older versions of Excel, beginning with version 2.0.
In addition to doing file conversions, XLSConverterX also adds enhanced features and some basic data massaging methods to further enhance its usefulness. If you need to include Excel manipulation capability in your program, XLSConverterX offers numerous specialized processes including:
· Copy specific sheet data from one worksheet to another within the same or a different workbook
· Concatenate/append specified data from a whole folder of workbooks to a single sheet
· Copy an entire worksheet (including formatting) to the same or a different workbook, and specify location within the target workbook
· Delete a single or whole range of sheets within a workbook
· Add a new sheet and specify where to place the new sheet within the workbook
· Move a sheet to a specific place within a workbook
· Rename an existing sheet
In addition to the worksheet manipulation, many other special processes for CSV and/or text files have been built into XLSConverterX. These include:
· (*.TXT) Append (Concatenate) files. Original file(s) content is placed at the end of the Target file.
· (*.TXT) Remove empty lines
· (*.CSV) Surround field with quotes
· (*.CSV) Pad field with spaces
· (*.CSV) Change comma to other delimiter
· (*.CSV) Remove Empty Lines
· (*.CSV) Include specified ROWS, discard all others
· (*.CSV) Include specified COLUMNS, discard all others
· (*.CSV) Remove control characters
· (*.CSV) Trim excess commas
XLSConverterX encapsulates all the details required for quick integration. Furthermore, an extensive sample Visual Basic application is provided to get you up to speed quickly and demonstrates XLSConverterX's capability and usability. Although you may not be using Visual Basic, the approach for all development environments will be similar.
Simply install the product, and add the component to your development environment. Once in place, the routines can be accessed to programmatically convert and manipulate Excel files. The code required to integrate this component in an application is relatively small considering the functionality it provides.
This Reference section of this document discusses the Properties, Methods, and Events that are exposed by the XLSConverterX component. Please check Distributing XLSConverterX for information concerning which files are required when distributing XLSConverterX.
Please Note: In those cases where an Excel file is used, this product automates MS Excel to convert/manipulate the files; therefore, MS Excel is required. The user is encouraged to make sure Excel is properly licensed on the PC.
At SoftInterface, Inc. we are constantly enhancing and improving our products. Please visit our web site to see what is new and tell us what you would like to see in our products (WWW.SoftInterface.COM). In addition, it is important to register your products to ensure you have the latest version and support.