Keywords: delphi, read, write, excel, excel files, XLS, XLSX

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

XLSReadWriteII uses it's own memory manager that is optimized for storing cell values. This means that you can work with larger files. If your files still not will fit in memory, there is a Direct Read and Direct Write modes that let you process files on disc.

Stability. One of the major goals with XLSReadWriteII was to create a product that won't corrupt the Excel files and won't alter any data in the file. The engine that handles XLSX files is automatically built directly from the file format specifications with our special developed tool. This will ensure maximum compatibility.

No runtime fees for the component.

Full source code included.

Key features:

Read and write any cell value...
Numeric, string, boolean and error cells.
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 and 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.

Calculation:
Fast calculation engine with support for all standard Excel formulas.
The calculation engine will calculate dependent cells, if there are any.

You can also work with:
Charts, Pivot tables, Encrypt, Import, Export and much more.