Allows to create formula references data in Excel sheet. Allows to create charts references data in Excel sheet.

And more...
 
With Nag-Screen
Source: N/A

With NativeExcel v2.x you can open and modify an existing spreadsheet.

Advantages:

• High performance (30000-40000 values per second)
• Convenient object model
• Support for all Excel formatting options
• Microsoft Office is not required
• Compatibility with standard Delphi's Excel components
• TDataset2Excel component. Populates a spreadsheet from TDataset descendants
• TDBGrid2Excel component. Populates a spreadsheet from TDBGrid descendants

• Open an existing excel file
• Access any cell values (number, string, date, formula)
• Calculation engine to perform computation on the cells
• Cell attributes (alignment, orientation, comments, borders, background attributes, and so on)
• Font attributes (font name, font size, color, decoration, and so on)
• Merged cells
• Images
• It preserves existing charts
• Unicode characters support
• Copy/Move/Delete/Insert range of cells
• Group/Ungroup rows and columns
• Worksheet attributes (name, protection, selection, and so on)
• Printing attributes (page size, orientation, margins, footer, header, page breaks, and so on)
• Exporting workbooks and worksheets to HTML, RTF, CSV, TSV files.

Online help and code for extremely high data transfer rates (1000+ items in less than 25 milli seconds on a PII) are available.
 
Fully functional
Source: Included

Simple checker (demo) of component added.
 
Fully functional
Source: Included

It is based on direct reading and writing of files, and works without OLE Automation with Microsoft Excel.

• Reading and writing speed is about 75 000 cells per second.
• TXLSFile supports MS Excel 97, 2000, XP, 2003 format (BIFF8).
• XLS files produced by TXLSFile may be opened in OpenOffice.
• TXLSFile is distributed as Borland Delphi source code which is compatible with Borland Delphi 3-2007.
• Contains functions for export of Excel data to HTML, TXT.
• Contains XLSExport components for quick export of TDBGrid, TDataSource, TStringGrid components to Excel file.

Demo exe shows most of its features (put data into cells with alignment, set colums width, create XLS file, open Excel).
 
Fully functional
Source: Included
Exe-Demo Included

This component supports:

• Fonts
• Headers and Footers
• Label, Integer, Double, Boolean, BoolErr fields
• Alignment settings
• Borders
• Shading
• Sheet and cell protection.

One of the major goals was to create a product that don't corrupts the Excel files and don't alter any data in the file. With XLSReadWriteII, you can always be sure that your Excel files can be read by Excel after you have edited them, and no data has been unexpected removed.

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

• Read, write and modify any Excel file.
• Read and write any cell values. Cells with multiple fonts formatting (Rich text) can be read and written directly to/from RTF files.
• Full support for formulas. You can use the same functions as in Excel. Formulas with references to external workbooks are supported as well. You can even read the result from an external reference.
• Cells and whole worksheets can be calculated and the calculation engine will calculate dependent cells, if there are any.
• Easy cell formatting, where the format properties are accessible trough the cell object. Whole ranges of cells can also be formatted, so it is easy to put a border around an area of cells.
• XLSReadWriteII has full support for Unicode. As all strings are WideString, you will not have any problems with non-English characters.
• Cell notes and text boxes are supported.
• All printing options are accessible.
• Control objects, such as list boxes, combo boxes, buttons etc. can used.
• Support for all kinds of drawing objects.
• Charts can be created with the same options as in Excel.
• Named cells and areas can be used. When a named cell is created, it can easily be accessed trough it's name.
• All types of hyperlinks are supported.
• Password protected (encrypted) files can be read and written.
• Read and write VBA macros. Macros can also be assigned to controls, pictures etc.
• Autofilters.
• Excel 2007 format support.
• You can also use: Cell validations, Conditional formats, Merged cells and more...

XLSReadWriteII is fast. Write 1,000,000 cells in less than a second.

The XLSReadWriteII package also include import methods for:

• Any TDataset database.
• Open Office Calc documents.
• CSV and other text files. Characters for field separator, decimal separator and text quote character are detected automatic.
• HTML tables (TABLE tag).

Data can be exported to:

• CSV text files.
• HTML files.

XLSSpreadSheet works togheter with XLSReadWriteII, wich 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.

The latest version of XLSReadWriteII is included when you purchase XLSSpreadSheet. XLSSpreadSheet also comes with components for printing and print preview.

You should have XLSReadWriteII installed to try this component.
 
Trial (work while IDE is running)
Source: On purchase/registration
Price: $640