TXLSFile is a Borland Delphi library for reading and writing of Microsoft Excel XLS files.
It is based on direct reading and writing of files, and works without OLE Automation with Microsoft Excel. VB and C++ developers may use OLE XLSFile COM objects library.


Features
Excel features

• TXLSFile does not require Microsoft Excel installed.
• TXLSFile supports MS Excel 97, 2000, XP, 2003 format (BIFF8).
• XLS files produced by TXLSFile may be opened in Excel 2007.
• XLS files produced by TXLSFile may be opened in OpenOffice.

Registered version

• The registered version contains a source code compatible with Borland Delphi 3-2007.
• XLSExport components are distributed with TXLSFile library.
• The product contains a complete documentation with a lot of samples.

Data handling

• TXLSFile contains functions for data export to HTML and TXT files.

File elements
With TXLSFile you can read and write the following Excel file elements.
File elements Write to
XLS file Read from
XLS file Cells and sheets All workbook' sheets + + Cell' values (numbers, text, Unicode text, dates, boolean values) + + Formulas + + Hyperlinks + No Merged cells + + Named areas + + Sheet, workbook, file protection + + Formats, styles, images Borders + + Built-in and custom format strings (e.g. '#,##0.00') + + Charts No No Font color, size and style + + Foreground and background colors, fill styles + + Images (supported formats are BMP and JPEG) + No Page setup (print layout, print area, paper size etc.) + + Row height and column width + + Rows and columns grouping + + Text rotation + + Window options (show/hide grid, repeatable rows etc.) + +
more info @http://sm-software.com/txlsfile.htm