| Here are some of
the advantages that you will have with XLSReadWriteII 4: |
|

|
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.
|
|

|
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;
- You can also format cell
areas, and for example, set a border around it.
- 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 WideString, you will not
have any problems with non-english characters.
|
|

|
Control objects.
You can insert controls and define their source and destination
cells.
|
|

|
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.
- Cells and whole worksheets can be
calculated
- 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.
|
|

|
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.
- HTML tables (<TABLE> tag).
- Databases.
Export data to...
- CSV text files.
- HTML files.
|
|

|
And more...
- Autofilters.
- Cell validations.
- Conditional formats.
- Merged cells.
- PaintCell method for rendering the
cell contents to a TCanvas object.
|
|

|
The XLSReadWriteII package also
includes components for:
- Importing any database into a
worksheet.
- Exporting worksheets to HTML files.
|
| |
XLSReadWriteII
is fast! Write more than 1,000,000 cells in less than a second! |