XLSReadWriteII is a high-performance software component that allows easy access to Excel XLS and XLSX files. It provides read and write capabilities for cell values, formatting, charts, pivot tables, as well as worksheet calculations and file encryption.

This software allows users to process files on disc through Direct Read and Direct Write modes, perfect for when their files won't fit in memory. Additionally, XLSReadWriteII was developed with stability in mind, ensuring that the Excel files remain uncorrupted and that there's no alteration of data within them.
XLSReadWriteII handles XLSX files seamlessly, and the engine used to handle them is automatically built directly from the file format specifications with a specially developed tool, to ensure maximum compatibility.
One significant advantage of XLSReadWriteII is that there are no runtime fees for the component, and the full source code is included. It has several key features, such as reading and writing any cell value, numeric, string, boolean, and error cells. Users can also access cells in the same way as the TStringGrid that comes with Delphi, or by giving them the cell as a string like 'D7.'
XLSReadWriteII is designed with optimal performance in mind. As Excel 2007+ files permit up to 16,000 x 1,000,000 cells, performance is critical. Reading and writing speed of Excel 2007+ files are at least twice as fast as Excel. Additionally, memory usage shall not be more than half of what Excel uses, and the memory manager reduces usage even further. Pre-Excel 2007 files are binary, which means they are read and write much faster.
Lastly, XLSReadWriteII has an incredibly fast calculation engine that supports all standard Excel formulas. The calculation engine will calculate dependent cells, if any, and users can work with charts, pivot tables, encrypt, import, export, and much more.
Overall, XLSReadWriteII is an excellent software for those who work with Excel files regularly. Its native access, stability, and calculation engine make it a standout product, offering fast and efficient performance with no runtime fees.
Version 6: Major release