XLSConverterX description
Easily integrate and Excel conversion utility into your own application.
XLSConverterX is a useful ActiveX component specifically designed to provide you with the possibility to easily integrate an Excel manipulation/conversion utility into your application. XLSConverterX is designed to manipulate comma delimited CSV, MS Excel files, and any files MS Excel can open.
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.
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.
Here are some key features of "XLSConverterX":
· Convert to/from Excel to many file types including CSV, XML, HTM, TXT, SLK, DBF, Lotus, WKS (only to wks) and others. See below for listing.
· Quick integration of this ActiveX component is easy since sample source code is provided.
· 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(s) 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
· Delete specific rows or columns from a worksheet
· 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
· Print sheet(s) and specify ranges
· Transpose data by converting rows to columns and columns to rows.
· Many other special processes for CSV and/or text files have been built into XLSConverterX
append/concatenate files; original file content is placed at the end of the target file
remove empty lines
surround field with quotes
pad field with spaces
change comma to other delimiter
remove empty lines
create fixed width fields
include specified rows, discard all others
include specified columns, discard all others
remove control characters
trim excess commas