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-2010.
- XLSExport components are distributed with TXLSFile library.
- The registered version contains complete product documentation with a lot of samples.
Demo version
- All features of the registered version are also available in the demo version!
- The only demo limitation is that Borland Delphi IDE must be running.
- The demo version contains DCUs (Delphi Compiled Units) and complete product documentation.
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's values (numbers, text, Unicode text, dates, boolean values) |
+ |
+ |
Cell's comments |
+ |
+ |
Cell's validations |
+ |
+ |
Formulas |
+ |
+ |
Hyperlinks |
+ |
+ |
Merged cells |
+ |
+ |
Named areas |
+ |
+ |
Protection for sheets, workbooks, files |
+ |
+ |
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, JPEG, PNG) |
+ |
+ |
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.) |
+ |
+ |
|