XLSReadWriteII 3.0

XLSReadWriteII is a Delphi component for reading and writing Excel files.

You will have:

* Native access to Excel files. The user doesnt need to have Excel, or any other software installed.

* XLSReadWriteII works as an invisible Excel workbook. All cell values are always accessible.

* Stability. One of the major goals was to create a product that wont corrupt the Excel files and wont alter any data in the file.

* XLSReadWriteII is easy to use. With the new formatting interface in version 2.0, you can format cells through a cell object.

* No runtime fees for the component.

* Full source code included.

Read and write any cell values:

* All cell values.

* 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 wan:

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

XLSReadWriteII has full support for unicode.

You can insert controls and define their source and destination cells.

Insert all kinds of drawing objects, from simple lines to AutoShapes.

Create and edit text boxes and cell notes as you want.

Create charts with the same options as in Excel.

Calculate worksheets.

VBA Macros can be read and written .

Import data from Open Office, CSV, HTML and more.