HeHere are some of the advantages that you will have
with XLSReadWriteII 5: |
|
Read and write any cell values...
- Numeric, string,
boolean and error cells. But what about date and time cells? There
are no such cells in Excel. Excel store date and time values in the
same way as Delphi, i.e. as floating point numbers. What make's it a
date or time value, is the formatting.
- Full support for
formulas. You can use the same functions as in Excel. Formulas with
referrences to external workbooks are supported as well. You can
even read the result from an external referrense.
- Cells are accessed in
the same way as the TStringGrid that comes with Delphi, or by giving
the cell as a string, like: 'D7'.
- Read cell values as a
string formatted according to the rules of the cell.
|
|
Performance
- XLSReadWriteII is
designed with optimal performance in mind. As Excel 2007+ files
permits up to 16,000 x 1,000,000 cells, performance is important.
- Read and write speed
of Excel 2007+ files at least twice as fast as Excel. As these files
are compressed XML files both decompressor anb XML parser must be
fast.
- XLSReadWriteII uses
it's own memory manager. Memory usage shall not be more than half of
what
Excel uses, and most times it's much less than that.
- Due to the fact that
pre Excel 2007 files are binary file, these files are read and
written much faster.
|
|
Format
the cells as you want...
- Formatting is easy.
By adressing the cell, you can access the formatting properties for
it. Example:XLSReadWriteII.Sheet[n].Cell[Col,Row].FontSize :=
12;
- XLSReadWriteII has
objects for formatting a worksheet in the same way as the Excel
Format Cells dialog. You can format cells or areas of cells in the
same way as Excel.
- Support for all Excel
formatting options.
- Use merged cells.
|
|
Access all printing options...
- Select paper size,
set margins.
- Set header and
footer, including formatting codes.
- Define printing
areas.
- Set page breaks.
|
|
XLSReadWriteII has full support for
unicode.
As all strings are Unicode, you will not have any problems with
non-english characters.
|
|
Direct Read and Direct Write.
You can read and write cells directly from the file, without
storing them in memory. As an Excel 2007+ file can contain up to 16
billion cells this ca be important if you want to save memory.
|
|
Drawing objects.
Insert all kinds of drawing objects, from simple lines to
AutoShapes.
|
|
Cell notes and text boxes.
Create and edit text boxes and cell notes as you want.
|
|
Charts.
Create charts with the same options as in Excel.
|
|
Copy/Move/Delete
- Cells can be copied, moved and
deleted with the same behaviour as in Excel.
- Rows and columns can be copied and
moved as well.
- Copy/move between sheets are
supported.
- Entire sheets can be copied.
|
|
Use named areas/cells.
- Names can be used where you want.
- Access cells through their name is
easy. Example:
XLS.NameAsFloat['MyCell']
:= 202.5;
- Support for special, built in names.
|
|
All types of hyperlinks are supported.
- Web and e-mail address.
- Local files.
- Server files.
- Worksheet referrences.
|
|
Encrypted documents.
You can read and write encrypted files. This assumes of course that
you know the password for the file you reads.
|
|
Calculation.
- Fast calculation engine with support
for all standard Excel furmulas.
- The calculation engine will
calculate dependent cells, if there are any.
- Referrences to external workbooks
will be read. This is performed with a special fast seek routine.
|
|
Rich Text cells.
In order to easy create cells with multiple font formatting, the
cells can be read and written in the Rich Text (RTF) format or with
html-like tags:
'A line with <b>bold</b>
and <i>italic</i> text.'
|
|
VBA Macros.
Macros in files can be read and written Macros that are created
with XLSReadWriteII can be assigned can be assigned to control
objects such as buttons, combo boxes etc.
|
|
Import and export.
Import data from...
- Open Office Calc documents.
- CSV and other text files with
automatic detection of characters for field separator, decimal
separator and text quote character.
- Databases.
Export data to...
- CSV text files.
- HTML files.
|
|
And more...
- Autofilters.
- Cell validations.
- Conditional formats.
- Merged cells.
|
|
The XLSReadWriteII package also includes
components for:
- Importing any database into a
worksheet.font>
- Exporting worksheets to HTML files.
|
|
|