XLSReadWriteII v126.96.36.199 for D7-D10.3 Rio Full Source
Native access to Excel files. The user doesn’t 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 comatibility.
No runtime fees for the component.
Full source code included.
We released the first version of XLSReadWrite in 1998. At that time it was the only component that could read and write Excel 97+ files. We are commited to have the leading Excel solution for Delphi in the future as well.Version 6 released!
Support for pivot tables.
New component: TXLSGrid. This is like a simpler version of XLSSpreadSheet where you can view cells, pictures and text boxes. Based on TDrawGrid.
You can now copy entire worksheets from other files (instances of XLSReadWriteII). Use the Assign method.
New RTF importer and exporter where you can import entire documents to a worksheet, including tables in RTF files.
Support for charts in XLSX files.
Support fo encrypted XLSX files.
Read and write any cell value…
Numeric, string, boolean and error cells.
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.
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 usesit’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.
With XLSSpreadSheet, you can work with Excel files just as they in Excel itself. The component don’t need any other software or libraries to be installed.
XLSSpreadSheet works togheter with XLSReadWriteII, which also is included. XLSSpreadSheet is easy to use. If you are familiar with XLSReadWriteII, you allready have the knowledge that’s needed, as all control of the Excel data is trough the XLSReadWriteII object of XLSSpreadSheet.