|
|
|
|
TXLSFile
|
TXLSFile is a Borland Delphi library for reading and writing
Microsoft Excel XLS files directly.
It does not use or require Microsoft Excel, and lets you bypass OLE Automation.
VB and C++ developers may use OLE XLSFile
ActiveX objects library.
|
|
|
|
|
|
|
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 - Embarcadero Delphi XE2.
- 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.) |
+ |
+ |
|
|
|
Screenshots of Excel XLS files produced by TXLSFile.
Formatted cells
|
Merged cells
|
Images
|
Rich text format
|
|
|
|
|
|
|
|
|
